Alter table to drop table column : Drop Column « Table « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Table
3. Drop Column

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>
           
       

Related examples in the same category