DROP TABLE Statement

DROP TABLE statement allows you drop an existing table in database which is useful in some programming situations. For example, you can use CREATE TABLE statement to create a temporary table to store your temporary data and after retrieve data from temporary table you can use DROP TABLE to remove it from database. Here is the code recipe for dropping a table:

DROP TABLE table_name

And an example of dropping employee table

DROP TABLE employee

With DROP you are not only limited in remove table from database you can only use it to delete an INDEX or a database. Here are the syntaxes:

DROP DATABASE database_name

DROP INDEX index_name