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

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💬

sys.indexes - Viewing Existing Indexes on an Given Table in SQL Server
How To View Existing Indexes on an Given Table using sys.indexes in SQL Server? 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"... 2016-11-15, 837👍, 0💬

CREATE INDEX - Adding an Index on an Existing Table in SQL Server
How To Create an Index on an Existing Table in SQL Server? If you want to an index on an existing table, you can use the CREATE INDEX statement in a simple syntax: CREATE INDEX index_name ON table_name (column_name) The tutorial exercise below shows you how to add an index for the "in" column of the... 2016-11-15, 750👍, 0💬

DROP INDEX - Removing Existing Indexes in SQL Server
How To Drop Existing Indexes in SQL Server? For some reason, if you want remove an existing index, you can use the DROP INDEX statement with following syntax: CREATE INDEX table_name.index_name The tutorial exercise below shows you how to remove the index "fyi_links_id": USE FyiCenterData; GO SELECT... 2016-11-15, 709👍, 0💬

SP_HELP - Viewing Existing Indexes on an Given Table in SQL Server
How To View Existing Indexes on an Given Table using SP_HELP in SQL Server? 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 t... 2016-11-15, 677👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.