Deleting Table With Query in MS SQL

The following method is used to delete (drop) a table by writing a query in MS SQL.

DROP TABLE {Table Name}

You have to be careful when using this type of query! Because by running this query, everything including the definition of the table, all data, indexes, triggers and constraints will be removed.

An example of usage is as follows..

DROP TABLE TBL_PERSON_INFO


You May Interest

What is the Difference Between VARCHAR and VARCHAR(MAX) Datatypes ...

What is the Difference Between Clustered and a Non-clustered Inde ...

What are Replication and Database Mirroring in SQL Server ?

MS SQL Show Only Date of Current Time

What is Blocking in SQL Server ?