Alter table to Drop column in SQL Server

Posted by Ranjeet_8 under Sql Server category on 8/14/2012 | Points: 40 | Views : 2319

Create Table:

CREATE TABLE [dbo].[Employee](
	[First_Name] [varchar](50) NULL,
	[City] [varchar](50) NULL
)

Alter table to Drop column:

ALTER TABLE Employee
Drop Column City

Bookmark It

Posted by: Srilu.Nayini577 on: 8/11/2012 Level:Starter | Status: [Member] | Points: 10

ALTER TABLE Tablename DROP COLUMN columnname

Latest Code Snipptes