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.
For demonstration, we are using the wideworldimportors demo database – you can download it from here.
The syntax of the DROP TABLE statement is as follows:
Drop table [Database_name].[Schema_name].[table_name]
#sql server #sql drop table #sql