SQL Server - Rename Indexes

renameIndexes.sql

;WITH details AS(
select i.object_id
     , upper(t.name) as table_name
     , i.index_id
     , i.name as index_name
     , i.is_unique_constraint
     , i.is_primary_key
     , CASE is_primary_key WHEN 1 THEN 'PK_'
       ELSE
         CASE is_unique_constraint
         WHEN 1 THEN 'UK_' ELSE 'IX_'
         END
       END AS prefix
     , replace((
	     select '_' + lower(cols.name) AS [data()]
           from sys.index_columns ic 
           join sys.columns cols on cols.object_id = ic.object_id and cols.column_id = ic.column_id
		  where ic.object_id = i.object_id and ic.index_id = i.index_id
            and ic.is_included_column = 0
		  order by ic.index_column_id
		  for xml path ('')
	   ), ' ', '') as column_list
     , (
	     select TOP 1 '_INCLUDE' 
           from sys.index_columns ic 
           join sys.columns cols on cols.object_id = ic.object_id and cols.column_id = ic.column_id
		  where ic.object_id = i.object_id and ic.index_id = i.index_id
            and ic.is_included_column = 1
     ) as include_columns
  from sys.indexes i
  join sys.tables t on t.object_id = i.object_id
 where i.type_desc IN ('CLUSTERED','NONCLUSTERED')
   and SCHEMA_NAME(t.schema_id) = 'dbo'
), build AS (
select table_name
     , index_name
     , SUBSTRING(
         prefix
       + table_name
       + CASE is_primary_key WHEN 0 THEN column_list ELSE '' END
       + CASE WHEN include_columns IS NULL THEN '' ELSE include_columns END
       , 1, 128) new_index_name
  from details
)
select index_name, new_index_name, 'EXEC sp_rename N''dbo.' + table_name + '.[' + index_name + ']'', N''' + new_index_name + ''', N''INDEX'';' cmd
  from build
 where index_name <> new_index_name
 order by table_name, index_name