How to check if a column exists in MSSQL

To check if a column exists in MSSQL you can use the following snippet.

Sample MSSQL

SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('Pricetable') AND name='Price'

May 22, 2015 Administrator

Apr 21, 2015 Administrator

Apr 15, 2015 Administrator

Realliferulor says:

January 20, 2015 at 2:37 pm

RT @CodeSnippetsNET: Check if a column exists in #MSSQL http://t.co/om83qldAsl #SQL #coding #dev #programming

Log in to Reply