Table of Contents

Class ObjectSchema.MemoryOptimizedTablesInternalAttribute

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.memory_optimized_tables_internal_attributes (Transact-SQL)

Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance

Contains a row for each internal memory-optimized table used for storing user memory-optimized tables. Each user table corresponds to one or more internal tables. A single table is used for the core data storage. Additional internal tables are used to support features such as temporal, columnstore index and off-row (LOB) storage for memory-optimized tables.


See sys.memory_optimized_tables_internal_attributes.

[Table(Schema = "sys", Name = "memory_optimized_tables_internal_attributes", IsView = true)]
public class ObjectSchema.MemoryOptimizedTablesInternalAttribute
Inheritance
ObjectSchema.MemoryOptimizedTablesInternalAttribute
Extension Methods

Properties

MinorID

0 indicates a user or internal table

Non-0 indicates the ID of a column stored off-row. Joins with column_id in sys.columns.

Each column stored off-row has a corresponding row in this system view.

[Column("minor_id")]
[NotNull]
public int MinorID { get; set; }

Property Value

int

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

ID of the user table. Internal memory-optimized tables that exist to support a user table (such as off-row storage or deleted rows in case of Hk/Columnstore combinations) have the same object_id as their parent.

[Column("object_id")]
[Nullable]
public int? ObjectID { get; set; }

Property Value

int?

TypeColumn

Type of internal table.

0 => DELETED_ROWS_TABLE
1 => USER_TABLE
2 => DICTIONARIES_TABLE
3 => SEGMENTS_TABLE
4 => ROW_GROUPS_INFO_TABLE
5 => INTERNAL OFF-ROW DATA TABLE
252 => INTERNAL_TEMPORAL_HISTORY_TABLE

[Column("type")]
[Nullable]
public int? TypeColumn { get; set; }

Property Value

int?

TypeDesc

Description of the type

DELETED_ROWS_TABLE -> Internal table tracking deleted rows for a columnstore index
USER_TABLE -> Table containing the in-row user data
DICTIONARIES_TABLE -> Dictionaries for a columnstore index
SEGMENTS_TABLE -> Compressed segments for a columnstore index
ROW_GROUPS_INFO_TABLE -> Metadata about compressed row groups of a columnstore index
INTERNAL OFF-ROW DATA TABLE -> Internal table used for storage of an off-row column. In this case, minor_id reflects the column_id.
INTERNAL_TEMPORAL_HISTORY_TABLE -> Hot tail of the disk-based history table. Rows inserted into the history are inserted into this internal memory-optimized table first. There is a background task that asynchronously moves rows from this internal table to the disk-based history table.

[Column("type_desc")]
[NotNull]
public string TypeDesc { get; set; }

Property Value

string

XtpObjectID

In-Memory OLTP object ID corresponding to the internal memory-optimized table that is used to support the user table. It is unique within the database and it can change over the lifetime of the object.

[Column("xtp_object_id")]
[NotNull]
public long XtpObjectID { get; set; }

Property Value

long