IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'otherProperties' AND COLUMN_NAME = 'Url') begin alter table otherProperties add Url nvarchar(1000) end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'otherProperties' AND COLUMN_NAME = 'Sharh') begin alter table otherProperties add Sharh nvarchar(max) end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'otherProperties' AND COLUMN_NAME = 'Thumbnail') begin alter table otherProperties add Thumbnail nvarchar(1000) end