SQL – Drop Table

SQL – Drop Table is DDL (Data definition language) statement.The Drop Table command is used to delete table from database.

Drop Table Statement :

• Removes named table and all rows within it.
• Removes data indexes, triggers, constraints for named table.

Syntax For Drop Table :

Basic syntax for Drop table is as follows :

DROP TABLE Table_name

Please note that once the table is deleted all the information available in table will be deleted forever. So always be careful before using drop statement.

READ HERE : SQL – ALTER TABLE