IF EXISTS(SELECT * FROM sys.columns WHERE Name = N'columnName' AND Object_ID = Object_ID(qualified.table.name')) BEGIN PRINT 'Column Exists' END --OR IF COL_LENGTH('qualified.table.name','column_name') IS NULL BEGIN PRINT 'Column does not exist or caller does not have permission to view the object' END
No comments:
Post a Comment