View MS SQL Index Information

SQL Server transact SQL statement to fetch information on table indexes.