Published on: 23 Dec, 2020

How to delete a column of a table in TSQL?

Tumblr Digg Google Plus

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

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.