SQL Drop Table

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.

StudentID Student_Name Address City
1 Nithin Bank street Hyderabad
2 Bharath Panama street California

 

DROP TABLE Student;

 

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.