Wednesday, March 26, 2014

MSSQL: Does the column exits in a table

select * from sys.columns
         where
Name = N'[column name]'
and Object_ID = Object_ID(N'[Table Name]')

No comments:

Post a Comment