Tibor Karaszi has created a very useful index information stored procedure for SQL Server 2005 and up.

This stored procedure will tell you the following”

What indexes exists for a or each table(s)

Clustered, non-clustered or heap

Columns in the index

Included columns in the index

Unique or nonunique

Number rows in the table

Space usage

How frequently the indexes has been used

Check it out here: http://www.karaszi.com/SQLServer/util_sp_indexinfo.asp