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, 1452🔥, 0💬
Popular Posts:
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...