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.
![](http://85.147.245.113/mirrorbooks/mysqlcrashcourse/0672327120/0672327120/images/pixel.jpg) |