SQL Server: 06 – ALTER and DROP Statement

ALTER Statement in SQL

To add a column in a table, use the following syntax:

ALTER TABLE table_name
ADD column_name datatype

To delete a column in a table, use the following syntax:

 ALTER TABLE table_name
DROP COLUMN column_name