IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tafsili' AND COLUMN_NAME = 'CodeGroohAmval') begin print 'Ok' end else begin alter table tafsili add CodeGroohAmval int references groohAmval(code) end