Mega Code Archive

 

Categories / MSSQL / Table

 

Alter table to add column

1> --  2> 3> CREATE TABLE Appointment 4>    (   AppointmentID     Int 5>        , Description     VarChar(50) 6>        , StartDateTime   DateTime 7>        , EndDateTime     DateTime 8>        , Resource        VarChar(50) Null 9>    ) 10> GO 1> 2> ALTER TABLE Appointment 3> ADD LeadTime SmallInt Null 4> GO 1> 2> drop table Appointment 3> GO 1>