Check if a column exists in table

Some times we come across a scenario where we need to know if a specific columns exists in table or not. There are variety of ways to find existence of a column in table within SQL Server. In this short article, I will list out some commonly used practices to check existence of a column.

Method 1

This method only works on SQL Server 2005 and later.

Method 2

Method 3

following methods work on older version of SQL Servers such as SQL Server 2000.

You may also like...