SQL drop table command

Quick Reach

A few main points about the drop table command are:

The drop table command is used to delete or drop a table from the SQL database.
The drop command permanently removes the table from database.
All data is also removed in the dropped table.
Along with data all table structure and constraints like primary key, foreign key, unique keys etc. are also removed by using this command.

The syntax of the drop table SQL command is:

Drop table table_name

Following is the drop table command example where we will delete our example table tbl_employee.

1	Drop table tbl_emploee

The above SQL statement will remove the tbl_employee table including all data, fields, any primary or foreign keys and other constraints.