SQL DROP TABLE Statement

In this tutorial, we'll learn about deleting tables in SQL with examples.

In SQL, DROP TABLE is used to delete the tables in our database. For example,

DROP TABLE my_table;

Here, the SQL command will delete a table named my_table.

Also make sure you have admin or DROP permission to run this command.

Note: When we delete a database table, all records within a table are also deleted.


DROP TABLE IF EXISTS

While dropping a table that does not exist, throws an error. To fix this issue, we can add an optional IF EXISTS command while dropping a table. For example,

DROP TABLE IF EXISTS my_table;

Here, the SQL command will only drop a table if there is one with a same name.


Recommended Reading

Table of Contents

Did you find this article helpful?