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|
Introduction To Client/server Architecture
About Firebird Data Types
Date And Time Types
Blobs And Arrays
From Drawing Board To Database
Creating And Maintaining A Database
Firebird’s Sql Language
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Overview Of Firebird Transactions In
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Error Handling And Events
Security In The Operating Environment
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.