MySQL — Drop Table

Basic DROP TABLE

DROP TABLE users;

DROP TABLE IF EXISTS

DROP TABLE IF EXISTS users;

Dropping Multiple Tables

DROP TABLE users, products, orders;

Examples

-- Drop single table
DROP TABLE test_data;

-- Drop if exists
DROP TABLE IF EXISTS old_table;

-- Drop multiple tables
DROP TABLE IF EXISTS table1, table2, table3;

-- Show remaining tables
SHOW TABLES;

Warning

-- This will delete ALL data!
DROP TABLE users;

-- Always backup first!
-- mysqldump -u root -p mydb users > users_backup.sql

Best Practices

1. Always backup before dropping
2. Use IF EXISTS to avoid errors
3. Check for foreign key dependencies
4. Verify the table name
5. Consider archiving data instead

Mini Practice

Write MySQL code that:

1. Drops a table
2. Drops if exists
3. Drops multiple tables
4. Shows remaining tables

Up Next

Next: Learn about Inserting Data.