Home > Code > SQL Server > Drop column in sqlserver using alter table syntax

Drop column in sqlserver using alter table syntax

by Thamil   on Jan 15, 2012   Category: SQL Server   |  Views: 1045    |  Points: 25   |  Gold 


To drop a column in sql server, we can use alter table syntax to drop any column from sql server
table as shown below.

ALTER TABLE table_name
DROP COLUMN column_name --To drop one column

ALTER TABLE table_name
DROP
(column_name1,column_name2) -- To drop many columns


sample query to drop column.

ALTER TABLE emp_name
DROP COLUMN modified_by;
GO


Post Code  |  Code Snippet Home

User Responses


No response found, be the first to review this code snippet.

Submit feedback about this code snippet

Please sign in to post feedback

Latest Posts