How to find the list of index in a table ?

SQL server provide system stored procedure to find the list of indexes in the Tables (or) View.

Syntax 

SP_HELPINDEX 'Object Name'

Example

The following example list the index name,description and its keys for the Employee table.