T-SQL Tutorial

SQL Alter Table Drop Column


Drop Column Syntax:

ALTER TABLE table_name
DROP COLUMN column_name

Employee table:

Column nameData_type
idint
namevarchar(250)
dep_idint
addressvarchar(400)

Drop Column Example:

ALTER TABLE employee
DROP COLUMN address;

Drop Column Result:

Column nameData_type
idint
namevarchar(250)
dep_idint