This topic has not yet been rated - Rate this topic

Internal System Views

SQL Server 2005

Internal system views are system views that make available low-level storage metadata for the SQL Server 2005 Database Engine.

The following table lists and describes the internal system views.

Important:
These views are for internal use only and are subject to change. Compatibility is not guaranteed.

View name	Description
sys.system_internals_partitions	Contains a combination of rowset and hobt information. There is a one-to-one correspondence between rowset and hobt.
sys.system_internals_partition_columns	Contains both rowset and hobt column information. It also contains type and other information redundantly copied from the catalog of the relational engine.
sys.system_internals_allocation_units	Contains a row for each allocation unit in the current database.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions