IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND COLUMN_NAME = 'Mat_ID') begin alter table Bargeh add Mat_ID bigint references Matter (ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'People' AND COLUMN_NAME = 'Mat_ID') begin alter table People add Mat_ID bigint references Matter (ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND COLUMN_NAME = 'Mat_ID') begin alter table Kala add Mat_ID bigint references Matter (ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DaryaftPardakht' AND COLUMN_NAME = 'Mat_ID') begin alter table DaryaftPardakht add Mat_ID bigint references Matter (ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'GardesheChek' AND COLUMN_NAME = 'Mat_ID') begin alter table GardesheChek add Mat_ID bigint references Matter (ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Karbar' AND COLUMN_NAME = 'Mat_ID') begin alter table Karbar add Mat_ID bigint references Matter (ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND COLUMN_NAME = 'Mat_ID') begin alter table KalaDarAnbar add Mat_ID bigint references Matter (ID) not null default -1 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'Mat_ID') begin alter table ProductDetail add Mat_ID bigint references Matter (ID) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'RepairDetail' AND COLUMN_NAME = 'Mat_ID') begin alter table RepairDetail add Mat_ID bigint references Matter (ID) not null default -1 end