IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'license' AND COLUMN_NAME = 'CodingLevelCount') begin alter table license add CodingLevelCount int not null default 0 end