MySQL Drop Database and Table

DROP DATABASE

The DROP DATABASE statement deletes an entire database, including every table, view, stored procedure, and trigger it contains. This is one of the most destructive commands in SQL — there is no built-in undo. Once executed successfully, the database and all associated files are removed from disk immediately.

DROP DATABASE test_shop;

DROP TABLE

DROP TABLE removes a single table's structure and all of its rows. Unlike DELETE or TRUNCATE, which only remove data, DROP TABLE also erases the table definition itself — columns, indexes, constraints, and all. Any foreign keys referencing the dropped table must be handled first, or the statement will fail.

DROP TABLE order_items;

Safer Dropping with IF EXISTS

Running DROP TABLE or DROP DATABASE on an object that does not exist raises an error, which can halt a script. Adding the IF EXISTS clause makes the statement a no-op instead of an error when the target is missing — this is especially useful in setup or teardown scripts that need to run repeatedly and idempotently.

DROP TABLE IF EXISTS invoices, invoice_items;

• DROP DATABASE removes the entire schema and everything inside it
• DROP TABLE removes a table's structure and data, but leaves the database intact
• IF EXISTS prevents an error when the target does not exist
• DROP TABLE can accept a comma-separated list of table names in one statement
• Foreign key relationships must be dropped or disabled before dropping a referenced table