Kiểm tra 1 column có tồn tại trong 1 table hay không?

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
 WHERE TABLE_SCHEMA='dbo' AND TABLE_NAME = 'tableName'
AND COLUMN_NAME = 'columnName'

--For example: Here is the script in Dev Enviroment

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
   WHERE TABLE_SCHEMA='dbo' AND 
   TABLE_NAME = 'SMIReporting' AND (COLUMN_NAME = 'BookedCurrencyCode'))    
 
 ALTER TABLE dbo.SMIReporting ADD
  BookedCurrencyCode nvarchar(3) NULL