Drop a Table

How to Drop a Table in SQL

Introduction:
In this article, you will learn what drop table is and how to drop a table in SQL.

Drop is the most important command of Data Definition Language(DLL). Drop command is used to delete a table, which is present in our database. If we allow this command in our SQL statement, all the data available in the table would also be lost.

Syntax:

drop table table_name;

Step 1: We write the command to drop a table.

Step 2: Select the command and execute it.

Now, our table is deleted.

Summary:
Thus, we learned, how drop is used to delete a table in SQL.