Learn how you can delete a column of a table in TSQL. Before deleting a column, it is always recommended to check if a column does exist in a table. This is to ensure the process of deleting is working fine.
We are going to use the EXISTS method to check if a column exists against the column schema in the INFORMATION_SCHEMA system table.
Let's consider we have the following table definition. We want to delete a PromotionDate column.p>
Here is the full TSQL code to delete the column of the Products table.
IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Products' AND COLUMN_NAME = 'PromotionDate' ) BEGIN ALTER TABLE Products DROP COLUMN PromotionDate; END