Returns one row for each object that is an internal table. Internal tables are automatically generated by SQL Server to support various features. Internal tables do not contain user-accessible data. Internal tables appear in the sys schema.
<Columns inherited from sys.objects>
For a list of columns that this view inherits, see sys.objects (Transact-SQL).
Type of the internal table:
201 = queue_messages
202 = xml_index_nodes
203 = fulltext_catalog_freelist
204 = fulltext_catalog_map
205 = query_notification
206 = service_broker_map
207 = extended_indexes (such as a spatial index)
208 = filestream_tombstone
209 = change_tracking
210 = tracked_committed_transactions
Description of the type of internal table:
ID of the parent, regardless of whether it is schema-scoped or not. Otherwise, 0 if there is no parent.
queue_messages = object_id of queue
xml_index_nodes = object_id of the xml index
fulltext_catalog_freelist = fulltext_catalog_id of the full-text catalog
fulltext_index_map = object_id of the full-text index
query_notification, or service_broker_map = 0
extended_indexes = object_id of an extended index, such as a spatial index
object_id of the table for which table tracking is enabled = change_tracking
Minor ID of the parent.
xml_index_nodes = index_id of the XML index
extended_indexes = index_id of an extended index, such as a spatial index
0 = queue_messages, fulltext_catalog_freelist, fulltext_index_map, query_notification, service_broker_map, or change_tracking
Non-zero value is the ID of data space (filegroup or partition-scheme) that holds the large object (LOB) data for this table.
Reserved for future use.
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.