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

Leave a Comment


x

You might be Interested in these Posts

Angular 2 - Video Tutorials and learning materials for Angular 2

Do you want to learn and build web and mobile apps using Angular 2 ?. You can find the list of tutor...

Video - What's coming in Angular 2.0

Video - What's coming in Angular 2.0 http://www.youtube.com/watch?v=zuMmCCDk6Fc&feature=youtu....

Video - Angular 2 Data Flow – Jeff Cross, Rob Wormald and Alex Rickabaugh

In this video from AngularConnect , Jeff Cross, Rob Wormald and Alex Rickabaugh talks about the Angu...