|Article Time Stamp: 15 September 2008, 23:33:18 GMT+7|
Microsoft SQL (MS SQL): Sample SQL Script to Check If A Column Exists
Let's say, that we want to check whether a column, already exists in our table or not. We named our column as clmn_a and the table as tbl_a. And if it doesn't exists, then we just print to the screen 'Not Exists' words. Otherwise, we just print 'Already Exists' words.