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