Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)