Alter table to Drop column in SQL Server

Ranjeet_8
Posted by Ranjeet_8 under Sql Server category on | Points: 40 | Views : 1254
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

Comments or Responses

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


ALTER TABLE Tablename DROP COLUMN columnname

Login to post response