IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND COLUMN_NAME = 'ShowYadAvari') begin print 'Ok' end else begin alter table Tafsili add ShowYadAvari bit not null default 0 end go IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND COLUMN_NAME = 'TedadRoozYadAvari') begin print 'Ok' end else begin alter table Tafsili Add TedadRoozYadAvari int not null default 0 end go IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Tafsili' AND COLUMN_NAME = 'MahiatYadAvari') begin print 'Ok' end else begin alter table Tafsili Add MahiatYadAvari smallint not null default 0 end