How to find if the Column Exists in a table in SQL Server?

Published on June 9, 2013 by abundantcode

Filed under SQL Server

Last modified June 9, 2013

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 3312 times

If you are looking to find if the column exists in a table in SQL Server, here’s a simple query to it.

Assume that the table name is “Articles” and the column name is “AbundantCodeType”, below is a sample query to know if the column exists in SQL Server.

How to find if the Column Exists in a table in SQL Server ?

If exists(select * from sys.columns

where Name = N'AbundantCodeType' and Object_ID = Object_ID(N'Articles'))

begin

/* Perform the logic since the column exists */

End
0saves
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


x

You might be Interested in these Posts

How to hide horizontal or vertical scroll bar using VBA Code in Excel ?

Here's a VBA code that hides the horizontal and vertical scroll bar in Microsoft Excel. How to hide...

Deleting all the hidden rows and columns in the active worksheet using VBA

Do you want to delete all the hidden rows and columns in the active worksheet in Microsoft Excel usi...

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...