if (SELECT c.max_length From sys.tables AS t Inner Join sys.columns c On t.Object_ID = c.Object_ID where t.name = 'OtherProperties' and c.name = 'Description') != -1 begin alter table OtherProperties alter column Description nvarchar(max) end