IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'Dom_ID') begin alter table KalaProperty add Dom_ID int references Domain(ID) not null default -1 end go IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'Acc_ID') begin alter table KalaProperty add Acc_ID int references Account(ID) null end go IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'AI_ID') begin alter table KalaProperty add AI_ID int references AccountItem(ID) null end go IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'KarIdCreator') begin alter table KalaProperty add KarIdCreator int references Karbar(ID) null end go IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'TarikhSabt') begin alter table KalaProperty add TarikhSabt int not null default 0 end go IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaProperty' AND COLUMN_NAME = 'SaatSabt') begin alter table KalaProperty add SaatSabt int not null default 0 end