SQL Server Transact Basic to Expert - Dropping table column

SQL Server Transact Basic to Expert - Dropping table column

This blog shows how to drop a column in an existing table

Syntax:
ALTER TABLE table_name
DROP COLUMN column_name

Example:
Alter table emptable
Drop column empsal