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 TABLE table_name;
Let us take an example for using DROP on a table.
The Student Table looks like this and we use DROP on it.
DROP TABLE Student;
The student table will be completely removed from the database.
Now check the table
Query ok, o rows affected.
As the table is dropped it will not display any data.