IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Domain' AND COLUMN_NAME = 'Dom_ID_Type') begin alter table Domain add Dom_ID_Type int references Domain (ID) null end