Dropping Tables

Intermediate SQL

Dropping Tables

🙋 Need help? Ask an expert now!

How to Drop a Table

Let's look at into how we can delete or drop a table!

The drop table command is used to delete a table and all of its rows

Dropping tables is different than deleting all records because it removes the table definition as well as all of its rows.

Drop Table Command

DROP TABLE "tablename";

Example

DROP TABLE Employees;
Edit Me on GitHub!