SQL DROP TABLE statement is used to delete the contents of the table and also the structure of the table.

SQL DROP is to be used when you are to completely remove a table from a database.

After SQL DROP statement you cannot retrieve the table again so be careful while using DROP


The syntax for SQL DROP Statement is

DROP TABLEtable_name;


Let us take an example for using DROP on a table.

The Student Table looks like this and we use DROP on it.

1NithinBank streetHyderabad
2BharathPanama streetCalifornia




The student table will be completely removed from the database.

Now check the table

DESC Student;


Query ok, o rows affected.

As the table is dropped it will not display any data.