Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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

207 = extended_indexes (such as a spatial index)

208 = filestream_tombstone

209 = change_tracking

210 = tracked_committed_transactions

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

EXTENDED_INDEXES

FILESTREAM_TOMBSTONE

CHANGE_TRACKING

TRACKED_COMMITTED_TRANSACTIONS

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

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

parent_minor_id

int

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

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.