Total: 1 Average: 5
The SQL Server DROP TABLE statement serves to drop the table from the database. This article will explain some use scenarios and illustrate the work of the DROP TABLE statement by examples.
Read MoreTag: sql drop table
SQL DROP TABLE Statement and Various Use Cases
Total: 1 Average: 5
The SQL DROP TABLE statement serves to drop the table from the database. It removes the table and its data and indexes associated with it. The statement is irreversible. Thus, you can restore the table only by restoring the backup.
This article covers the following cases:
- Delete one or multiple tables.
- Delete the table used in a View.
- Delete the table having a foreign key.
- Delete the table having clustered and non-clustered indexes.
- Delete the table from the replication setup.