IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OtherProperties' AND COLUMN_NAME = 'Dom_ID_Detail') begin print 'Ok' end else begin alter table OtherProperties add Dom_ID_Detail Int references Domain(ID) end