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 fromdatabase. Here is the code sample for dropping a table:
And an example of dropping employee table
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: