Drop Table SQL Server

Drop Table SQL Server

Hi friends, in this post we will learn how to Drop Table SQL Server. Drop table removes all data, indexes, triggers, constraints, and permission specifications for that table.

Earlier we had discussed about Rename Table in SQL Server, Create Table SQL Server, Schema In SQL Server, SQL Server Operators, Data Type in SQL Server and Drop-Delete SQL Server Database Using Management Studio or Query.

Drop Table SQL Server Query:

----USE DATABASE IN WHICH WE WANT TO DROPTABLE----
USE Hightechnology
GO

----DROP TABLE SYNTAX WITH TABLE NAME----
DROP TABLE STUDENT
GO

Drop Table in SQL Server Management Studio:

1. Open SQL Server Management Studio, and connect to SQL Server.

2. Expand Database name > Right click on table, which you want to drop and click on Drop.

3. A dialog window will appear, which will ask for confirmation. Click on OK. Click on Show Dependencies to see dependencies.