To View Table Page Information
index-maintenance #index-maintenance#table
DBCC IND('databasename','tablename',0)
--0 for head structure
--2 for nonclustered index
--1 for clustered index DBCC IND('databasename','tablename',0)
--0 for head structure
--2 for nonclustered index
--1 for clustered index