DROP TABLE

The SQL DROP TABLE statement is used to remove a table definition and all data, indexes, triggers, constraints, and permission specifications for that table.

NP: You have to be careful while using this command because once a table is deleted then all the information available in the table would also be lost forever.

Syntax:

Basic syntax of DROP TABLE statement is as follows:

DROP TABLE table_name;

Example:

DESC EMPLOYEE1;

let us drop it as follows:

DROP TABLE employee1;

Now, if you would try DESC command, then you would get error as follows:

DESC employee1;

ERROR:TABLE employee1 doesn't exist