IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Repair' AND COLUMN_NAME = 'TechnicianDescription') begin alter table Repair add TechnicianDescription nvarchar(1000) null end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Repair' AND COLUMN_NAME = 'CustomerDescription') begin alter table Repair add CustomerDescription nvarchar(1000) null end