SQL

Finding Index on a table in SQL Server

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.
Ebook Download
View all
Basic SQL Queries
Read by 19.4k people
Download Now!
Learn
View all
Membership not found