Collections:
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?
✍: FYIcenter.com
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 ...
⇒ sys.indexes - Viewing Existing Indexes on an Given Table in SQL Server
⇐ CREATE INDEX - Adding an Index on an Existing Table in SQL Server
2016-11-15, 1471🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...