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.

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