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 ServerCreate Table SQL ServerSchema In SQL ServerSQL Server OperatorsData 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.

drop table sql server

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

drop table in sql server