SQL drop table command

The drop table command

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.

Syntax to remove a table

The syntax of the drop table SQL command is:

Drop table table_name

SQL drop table example

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

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

Also see SQL create table | SQL delete

Was this article helpful?

Related Articles

Leave A Comment?