sys.internal_tables

Description

Returns one row for each object that is an internal table. Internal tables are automatically generated by SQL Server to support various features. For example, when you create a primary XML index, SQL Server automatically creates an internal table to persist the shredded XML document data. Internal tables appear in the schema of every database and have unique, system-generated names that indicate their function, for example,

Syntax

xml_index_nodes_2021582240_32001