Quick steps: Viewing index information using sp_helpindex

• Published: 22 Jan 2006

The following excerpt, courtesy of Que Certification, is from Chapter 10 of the book MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation by Thomas Moore and Ed Tittel. Click for the complete book excerpt series or purchase the book.

STEP BY STEP - 10.4

Viewing index information using sp_helpindex

1. Open the Query Analyzer by selecting Query Analyzer from the Start menu.

---

2. To see the index-specific information about the indexes on the previously created table, IndexPractice, execute the following:

   EXEC sp_helpindex IndexPractice
   

---

3. Alternatively, you can query the sysindexes table to find more information about the index you created in Step by Step 10.3. To do so, execute the following:

   Use Pubs
   Select * from sysindexes
   where name = 'age_index'