IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TafsiliProperty' AND COLUMN_NAME = 'Taf_ID_Front') begin alter table dbo.TafsiliProperty Add Taf_ID_Front bigint references dbo.Tafsili(ID) null end