IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DaryaftPardakht' AND COLUMN_NAME = 'Taf_ID') begin alter table dbo.DaryaftPardakht add Taf_ID bigint references dbo.Tafsili(ID) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND COLUMN_NAME = 'Taf_ID_Bank') begin alter table dbo.Bargeh add Taf_ID_Bank bigint references dbo.Tafsili(ID) null end ; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND COLUMN_NAME = 'MablaghBank') begin alter table dbo.Bargeh add MablaghBank decimal(19,4) null end