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