SQL: Drop table

DROP TABLE command is used to drop table.

Syntax

DROP TABLE table_name;

mysql> SHOW TABLES;
+--------------------+
| Tables_in_sample   |
+--------------------+
| employe4           |
| employee           |
| employee_bangalore |
| employee_name      |
| test               |
| test1              |
| test2              |
+--------------------+
7 rows in set (0.00 sec)
 
mysql>
mysql> DROP TABLE employee_bangalore;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW TABLES;
+------------------+
| Tables_in_sample |
+------------------+
| employe4         |
| employee         |
| employee_name    |
| test             |
| test1            |
| test2            |
+------------------+
6 rows in set (0.00 sec)

Previous                                                 Next                                                 Home