IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND COLUMN_NAME = 'Dom_ID_HasSerial') begin alter table dbo.Kala add Dom_ID_HasSerial int references dbo.domain (ID) not null default 508 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND COLUMN_NAME = 'Dom_ID_HasSize') begin alter table dbo.Kala add Dom_ID_HasSize int references dbo.domain (ID) not null default 508 end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND COLUMN_NAME = 'Dom_ID_HasColor') begin alter table dbo.Kala add Dom_ID_HasColor int references dbo.domain (ID) not null default 508 end