ms sql remove column code example

Example 1: mssql remove column

ALTER TABLE table_name
DROP COLUMN column_name;

Example 2: sql delete column

Deletes a column from a table.
Example: Removes the first_name column from the users table.
ALTER TABLE users
DROP COLUMN first_name