How To Drop Table In SQL?

Use the `DROP TABLE` statement

Syntax: `DROP TABLE table_name;`

Example: `DROP TABLE employees;`

To avoid errors if the table may not exist: `DROP TABLE IF EXISTS table_name;`

To drop multiple tables: `DROP TABLE table1, table2;`

To remove dependent foreign key constraints first if required by the database

To confirm the table is removed, check the database schema or list of tables

Suggested for You

Trending Today