How to use Drop Command in SQL Server?
Introduction:
In this article i will explain what is Drop Command and how to use Drop Command in SQL Server.
Description:
In previous articles i explained How to create a table in SQL Server, How to alter table column in SQL Server, How to add a column to table and How to delete a column from table in SQL Server, How to rename a column and How to rename a table in SQL Server, Update Command, Delete Command, and Truncate Command. Now i will explain what is Drop Command and how to use Drop Command in SQL Server.
Drop command comes under DDL (Data definitionLanguage) command. By using Drop command we can drop a table from database.
Syntax:
Drop table <table-name>
Example:
Drop table Employee
Execute the above statement. Employee table will be dropped from database.
Note: Data along with table structure is also deleted.
-
CreatedOct 05, 2013
-
UpdatedOct 03, 2020
-
Views1,776