Question

What happens to the table structure when you use 'DROP TABLE' command in SQL?

• A. Table structure is truncated
• B. Table structure is deleted
• C. Table structure is modified
• D. Table structure remains intact

Answer 1

Answer:

B. Table structure is deleted

• The drop table command is used to delete a table and all rows in the table. 
• To delete an entire table including all of its rows, issue the drop table command followed by the table name.
• Drop table is different from deleting all of the records in the table.
• once a table is dropped, all its data, structure, and constraints are permanently deleted.
• We cannot recover it unless you have a backup of the database.