The SQL DROP TABLE statement is used to remove a table definition and all data, indexes, triggers, constraints, and permission specifications for that table.
NOTE: 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.
Now see the syntax to drop the table from the database.
DROP TABLE "table_name";
First test EMP table and then we would delete it from the database.
SQL> DESC EMP;
This shows that EMP table is available in the database, so we can drop it as follows:
SQL>DROP TABLE EMP;
Let's see the command to drop a table from the MySQL database.
DROP TABLE admin_emp;
Let's see the command to drop a table from Oracle database.
DROP TABLE sercive_emp;
Let's see the command to drop a table from SQLServer database. It is same as MySQL.
DROP TABLE production_emp;