sys.indexes - Viewing Existing Indexes on an Given Table in SQL Server

Q

How To View Existing Indexes on an Given Table using sys.indexes in SQL Server?

✍: FYIcenter.com

A

Another way to view existing indexes defined for a given table is to use the system view called "sys.indexes". The tutorial exercise shows you how many indexes were defined from the previous tutorial on table "fyi_links":

USE FyiCenterData;
GO

SELECT * FROM sys.indexes WHERE object_id = (
   SELECT object_id FROM sys.tables WHERE name = 'fyi_links'
);
GO
object_id  name           index_id  type_desc     is_unique
---------  -------------  --------  ----------    ---------
421576540  NULL           0         HEAP          0
421576540  fyi_links_id   2         NONCLUSTERED  0
421576540  fyi_links_url  3         NONCLUSTERED  0

The extra line in the query result is not a real index at this moment. It will be explained in another tutorial.

 

Understanding and Managing Indexes in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-15, 837👍, 0💬