SP_HELP - Viewing Existing Indexes on an Given Table in SQL Server

Q

How To View Existing Indexes on an Given Table using SP_HELP in SQL Server?

✍: FYIcenter.com

A

If you want to know how many indexes have been defined for a given table, you can use the SP_HELP built-in stored procedure in the following syntax:

EXEC SP_HELP table_name
-- Returns all database objects related the given table

The tutorial exercise shows you how many indexes were defined from the previous tutorial on table "fyi_links":

EXEC SP_HELP fyi_links;
GO
...

index_name      index_description                 index_keys
------------    -------------------------------   ----------
fyi_links_id    nonclustered located on PRIMARY   id
fyi_links_url   nonclustered located on PRIMARY   url
...

 

Understanding and Managing Indexes in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-15, 676👍, 0💬