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.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.