SQL Server: Delete Columns of a Table

Use ALTER TABLE DROP COLUMN statement to delete one or more columns of a table using T-SQL.

Syntax:

            ALTER TABLE [schema_name.]table_name 
DROP column column_name1, column_name2,... column_nameN;

The following deletes the Address column of the Employee table.

            ALTER TABLE dbo.Employee
DROP COLUMN Address;

The following deletes multiple columns of the Employee table.

            ALTER TABLE dbo.Employee
DROP COLUMN Address, PhoneNo, Email;

Delete Columns Using SSMS

Open SSMS and connect to the SQL Server instance. In Object explorer, expand the database and the Tables folder. Locate the table and expand the columns folder to display the column names.

Right-click on the column name which you want to delete and click delete.

This will open "Delete Object" page, as shown below.

Click OK to delete a column.

Finally, save the changes from File menu -> Save.