In this blog, I have described how to drop the 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