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

 

Leave a Reply