The following SQL will list all indexes in within the database that you run the sql script. I was looking for the option within Visual Studio - Data Dude add-on that displayed index differences between two databases. I eventually discovered the line by line index comparison by exploding the Table-Indexes however I was unable to create the newly added script index in the 2nd database. Is this possible?
In lieu of the shortcomings within Data-Dude I used the following script to manually compare and script the indexes in both databases.
DECLARE GetTables CURSOR READ_ONLY
FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND OBJECTPROPERTY (OBJECT_ID(TABLE_NAME), 'IsMSShipped') = 0
DECLARE @TableName sysname
OPEN GetTables
FETCH NEXT FROM GetTables INTO @TableName
WHILE (@@fetch_status = 0)
BEGIN
EXEC sp_helpindex @TableName
FETCH NEXT FROM GetTables INTO @TableName
END
CLOSE GetTables
DEALLOCATE GetTables