Use DROP TABLE to remove an entire table permanently from the database. This is permanent and, once committed, cannot be undone.
DROP TABLE name;
The following statement drops the table PERSONNEL:DROP TABLE PERSONNEL;
Sometimes, you may want to drop a table and create it again “from scratch.” For these occasions, Firebird has RECREATE TABLE, which does the following:
The syntax is identical to that of CREATE TABLE. Simply substitute the CREATE keyword with RECREATE and proceed.
Restrictions and Recommendations
If the table is in use when you submit the DROP or RECREATE statement, the request will be denied, with an “Object xxxxx is in use” message.
Always take a backup before any activity that changes metadata.
Although it is possible to make metadata changes when users are online, it is not recommended, especially for radical changes like dropping and re-creating tables. If necessary, force users off and get exclusive access.
Firebird Related Interview Questions
|RDBMS Interview Questions||MySQL Interview Questions|
|Linux Interview Questions||Mac OS X Deployment Interview Questions|
|Windows Administration Interview Questions||Windows Server 2003 Interview Questions|
|SQL Interview Questions||NoSQL Interview Questions|
|Advanced C++ Interview Questions|
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.