MySQL - DROP TABLE
How can we drop a table?
DROP TABLE table_name;
How can we drop multiple tables?
In MySQL, a single DROP TABLE statement can be used to drop multiple tables:
DROP TABLE t1, t2, t3;
How can we drop a table only if it exists?
DROP TABLE [IF EXISTS] t1;
The [IF EXISTS] clause prevent MySQL from generating an error message.
page revision: 3, last edited: 09 Apr 2016 15:59