IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'VoucherItem' AND COLUMN_NAME = 'AI_ID_Kol') begin alter table VoucherItem Add AI_ID_Kol int references AccountItem(ID) not null default -1 end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'VoucherItem' AND COLUMN_NAME = 'AI_ID_Moin') begin alter table VoucherItem Add AI_ID_Moin int references AccountItem(ID) null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'VoucherItem' AND COLUMN_NAME = 'AI_ID_Taf1') begin alter table VoucherItem Add AI_ID_Taf1 int references AccountItem(ID) null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'VoucherItem' AND COLUMN_NAME = 'AI_ID_Taf2') begin alter table VoucherItem Add AI_ID_Taf2 int references AccountItem(ID) null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'VoucherItem' AND COLUMN_NAME = 'AI_ID_Taf3') begin alter table VoucherItem Add AI_ID_Taf3 int references AccountItem(ID) null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'VoucherItem' AND COLUMN_NAME = 'AI_ID_Taf4') begin alter table VoucherItem Add AI_ID_Taf4 int references AccountItem(ID) null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'VoucherItem' AND COLUMN_NAME = 'Acc_Code') begin alter table VoucherItem Add Acc_Code nvarchar(100) null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'VoucherItem' AND COLUMN_NAME = 'Acc_Title') begin alter table VoucherItem Add Acc_Title nvarchar(1000) null end;