How to delete a column with T-SQL

How to delete a column with T-SQL

Step 1

To drop a column from your table use back the good old ALTER TABLE command. The following command will remove CreditCard column from your table called Employee.

USE DEMO

ALTER TABLE EMPLOYEE DROP COLUMN CREDITCARD

Step 2

After you press F5 you column will be removed.