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.
The following is the data in the table.
Now run the following script to find index if any in the above table
When we run the preceeding script we get the following resultset.