if exists(select * from sysindexes where id=object_id('FormDefinitionItem') and name='name_index') begin DROP INDEX name_index on FormDefinitionItem; ALTER TABLE FormDefinitionItem ALTER COLUMN name varchar(4000); create INDEX name_index on FormDefinitionItem(name); end; else begin ALTER TABLE FormDefinitionItem ALTER COLUMN name varchar(4000); create INDEX name_index on FormDefinitionItem(name); end;