Finding Index on a table in SQL Server

In this blog we will see how to find indexes on a table.

I have an employee table in my database. Let us check the content in the table.

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

sp_helpindex employee

When we run the preceeding script we get the following resultset.