How to check if a column exists in a table in SQL Server ?

Published on August 20, 2016 by abundantcode

Filed under SQL Server

Last modified August 20, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 324 times

If you want to find out if a column exists in a SQL Server table , you can use the sys.columns table and specify the name of the column and table as parameter.

How to check if a column exists in a table in SQL Server ?

For example , you want to find out if the GroupName column exists in the table "HumanResources.Department" table , your query will look this

Use AdventureWorks2014
FROM sys.columns 
WHERE Name      = N'GroupName'
AND Object_ID = Object_ID(N'HumanResources.Department') 

The result would be details of the column.


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

Displaying all the worksheet names in Excel using VBA Code

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it...

How to change positive numbers to negative in Microsoft Excel 2016 ?

Do you want to change the positive numbers to negative numbers and vice versa (or in simple terms) ,...

How to convert number to text in Excel?

In Microsoft Excel 2016 , there are times when you don't want the numbers present in the cell to be ...