IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TolidDetail' AND COLUMN_NAME = 'Dom_ID_Status') begin print 'Ok' end else begin alter table TolidDetail Add Dom_ID_Status int references Domain(ID) not null default 461 end IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TolidDetail' AND COLUMN_NAME = 'Tarikh') begin print 'Ok' end else begin alter table TolidDetail Add Tarikh int not null default 0 end