Drop Column in SQL Server

In this blog I have described how to drop column from existing table. For demonstration I have used a table that given below.

CREATE TABLE [dbo].[EmpInfo]

(

[ID] INT IDENTITY PRIMARY KEY,

[Name] VARCHAR(50),

[Date] VARCHAR(50)

)

Syntax:

ALTER TABLE <Table Name> DROP COLUMN <Column Name>

Example:

ALTER TABLE [dbo].[EmpInfo]

DROP COLUMN [Date]

Leave Comment