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
- Open the Query Analyzer by selecting Query Analyzer from the Start menu.
- To see the index-specific information about the indexes on the previously created table, IndexPractice, execute the following:
EXEC sp_helpindex IndexPractice
- 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'
Click for the complete book excerpt series.