Deleting Tables

Deleting tables (actually removing the entire table, not just the contents) is very easyarguably too easy. Tables are deleted using the DROP TABLE statement:

• Input

DROP TABLE customers2;

• Analysis

This statement deletes the customers2 table (assuming it exists). There is no confirmation, nor is there an undoexecuting the statement will permanently remove the table.