How to use Drop Command in SQL Server?
In this article i will explain what is Drop Command and how to use Drop Command in SQL Server.
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.
Drop table <table-name>
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