Remove table

By using 'DROP TABLE' statement, you can remove a table.

Syntax

DROP TABLE table_name;

mysql> DROP table employee;
Query OK, 0 rows affected (0.05 sec)

mysql> select * from employee;
ERROR 1146 (42S02): Table 'sample.employee' doesn't exist

Prevoius                                                 Next                                                 Home