login

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 fromdatabase. Here is the code sample 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
Read On