Delete or drop MySQL database tables
Written by Guillermo Garron
Date: 2013-05-24 17:12:13 00:00
Delete a MySQL Table
To delete one or more tables on a MySQL database we use the drop command.
Enter the MySQL command interface
mysql -u [user] -p
You will be prompted for for [users]'s password, and then you get the prompt.
Select the database
USE [database_name];
You can now list the tables of the database.
SHOW TABLES;
Delete tables from MySQL database
DROP TABLE [IF EXIST] [table 1], [table 2], [table n];
It is a good idea to use the 'IF EXISTS' option, to avoid errors if you are trying to drop a table that does not exists in the database.
Replaces 'table 1', 'table 2' and so on, for the table names you want to delete.