sqlserver 导出表的所有索引

DECLARE @TableName NVARCHAR(256) = 'TableName' COLLATE Chinese_PRC_CI_AS;
DECLARE @SchemaName NVARCHAR(256) = 'dbo' COLLATE Chinese_PRC_CI_AS;

SELECT 'CREATE ' + 
       CASE WHEN idx.is_unique = 1 THEN 'UNIQUE ' ELSE '' END +
       idx.type_desc + ' INDEX [' + idx.name + '] ON [' + @SchemaName + '].[' + @TableName + '] (' +
       STUFF((
            SELECT ', [' + col.name + ']' + 
                   CASE ic.is_descending_key WHEN 1 THEN ' DESC' ELSE '' END
            FROM sys.index_columns ic
            JOIN sys.columns col ON ic.object_id = col.object_id AND ic.column_id = col.column_id
            WHERE ic.object_id = idx.object_id AND ic.index_id = idx.index_id AND ic.is_included_column = 0
            ORDER BY ic.key_ordinal
            FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 2, '') COLLATE Chinese_PRC_CI_AS + ')' +

       CASE WHEN EXISTS (SELECT 1
                         FROM sys.index_columns ic
                         WHERE ic.object_id = idx.object_id 
                         AND ic.index_id = idx.index_id 
                         AND ic.is_included_column = 1)
            THEN ' INCLUDE (' + 
                 STUFF((
                     SELECT ', [' + col.name + ']'
                     FROM sys.index_columns ic
                     JOIN sys.columns col ON ic.object_id = col.object_id AND ic.column_id = col.column_id
                     WHERE ic.object_id = idx.object_id AND ic.index_id = idx.index_id AND ic.is_included_column = 1
                     FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 2, '') COLLATE Chinese_PRC_CI_AS + ')'
            ELSE '' END AS CreateIndexStatement
FROM sys.indexes idx
INNER JOIN sys.tables tbl ON idx.object_id = tbl.object_id
INNER JOIN sys.schemas sch ON tbl.schema_id = sch.schema_id
WHERE tbl.name = @TableName COLLATE Chinese_PRC_CI_AS
  AND sch.name = @SchemaName COLLATE Chinese_PRC_CI_AS
  AND idx.is_primary_key = 0  -- 过滤掉主键索引
ORDER BY idx.name COLLATE Chinese_PRC_CI_AS;