Mega Code Archive

 

Categories / MSSQL / Table

 

Alter table to drop table column

1> CREATE TABLE Appointment 2>    (   AppointmentID     Int 3>        , Description     VarChar(50) 4>        , StartDateTime   DateTime 5>        , EndDateTime     DateTime 6>        , Resource        VarChar(50) Null 7>    ) 8> GO 1> 2> ALTER TABLE Appointment 3> DROP COLUMN Resource 4> GO 1> 2> drop table Appointment 3> GO 1>