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