DBCC SQL Server 2000 sysindexkeys

Question

I have a SQL Server 2000 database. When I run the following command

select * from sysindexkeys

This display the appropriate records.

I then do a DBCC command for the sysindexkeys. It doesn't display anything. Strange there is no page having the sysindexkeys records. Then how the query display the list of records.

Answer 1

Interesting

Paul Randall wrote DBCC and he filtered out (see comment) system tables for some commands... but nothing on his blog

Answer 2

Thanks for the quick response. I found something more interesting for the same database. I did scan of the database page by page and then read the page header which stores the pageid and objectid (tableid).

Intersting there was no page allocated for object number 20 i.e. sysindexkeys. Something not clear as there is data when we do select * from sysindexkeys.

Can Paul Randell listening? Can he help me?

I'm making a management tool for our SQL Server 2000 database to check how the memory is allocated for the pages. Paul Randell blog really helped to understand the structure and code accordingly but now i'm really stuck.