sys.internal_tables (Transact-SQL)
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.
| Column name | Data type | Description |
|---|---|---|
<Columns inherited from sys.objects> |
|
For a list of columns that this view inherits, see sys.objects (Transact-SQL). |
internal_type |
tinyint |
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 |
internal_type_desc |
nvarchar(60) |
Description of the type of internal table: QUEUE_MESSAGES XML_INDEX_NODES FULLTEXT_CATALOG_FREELIST FULLTEXT_CATALOG_MAP QUERY_NOTIFICATION SERVICE_BROKER_MAP |
parent_id |
int |
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 |
parent_minor_id |
int |
Minor ID of the parent. xml_index_nodes = index_id of the XML index queue_messages, fulltext_catalog_freelist, fulltext_index_map, query_notification, or service_broker_map = 0 |
lob_data_space_id |
int |
Non-zero value is the ID of data space (filegroup or partition-scheme) that holds the large object (LOB) data for this table. |
filestream_data_space_id |
int |
Reserved for future use. |
See Also
Reference
Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)