How can I view the STRUCTURE of an indexed table in SQL Server?

63 views Asked by At

I have a general idea of what an indexed table looks like: first columns are indexed fields, last column is row id from the indexed table. But is there any way for me to actually view what a non-clustered indexed table looks like in SQL Server?

1

There are 1 answers

0
Markus Winand On

Have a look here: http://use-the-index-luke.com/sql/anatomy

It explains the internal structure of B-tree indexes in general.