Export (0) Print
Expand All

Internal System Views

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.

ms189600.note(en-US,SQL.90).gifImportant:
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.

Community Additions

ADD
Show:
© 2014 Microsoft