SQL script to check special characters in Index Name
select i . [name] as index_name , substring ( column_names , 1 , len ( column_names )- 1 ) as [columns] , case when i . [type] = 1 then 'Clustered index' when i . [type] = 2 then 'Nonclustered unique index' when i . [type] = 3 then 'XML index' when i . [type] = 4 then 'Spatial index' when i . [type] = 5 then 'Clustered columnstore index' when i . [type] = 6 then 'Nonclustered columnstore index' when i . [type] = 7 then 'Nonclustered hash index' end as index_type , case when i . is_unique = 1 then 'Unique' else 'Not unique' end as [unique] , schema_name ( t . schema_id ) + '.' + t . [name] as table_view , case when t . [type] = 'U' then 'Table' when t . [type] = 'V' then 'View' end as [obj