I have an employee table in my database. Let us check the content in the table.
  1. select * from employee
The following is the data in the table.



Now run the following script to find index if any in the above table
  1. sp_helpindex employee
When we run the preceeding script we get the following resultset.