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.