check sql index Clustered

checkClustered.sql

ALTER DATABASE test SET TRUSTWORTHY ON;
GO


SELECT 
	'CREATE INDEX ' + ix.name + ' ON ' + t.name + '(' + CAST(STRING_AGG(c.name, ', ') AS VARCHAR(MAX)) + ');' AS create_index_statement
FROM 
    sys.indexes ix
JOIN 
    sys.tables t ON ix.object_id = t.object_id
JOIN 
    sys.index_columns ic ON ic.index_id = ix.index_id AND ic.object_id = t.object_id
JOIN 
    sys.columns c ON c.column_id = ic.column_id AND c.object_id = t.object_id
GROUP BY 
    ix.name, t.name,C.name