Table of Contents

Class ChangeTrackingSchema.ChangeTrackingTable

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

Change Tracking Catalog Views - sys.change_tracking_tables

Applies to: √ SQL Server √ Azure SQL Database √ Azure SQL Managed Instance

Returns one row for each table in the current database that has change tracking enabled.


See sys.change_tracking_tables.

[Table(Schema = "sys", Name = "change_tracking_tables", IsView = true)]
public class ChangeTrackingSchema.ChangeTrackingTable
Inheritance
ChangeTrackingSchema.ChangeTrackingTable
Inherited Members
Extension Methods

Properties

BeginVersion

begin_version NULL bigint

Version of the database when change tracking began for the table. This version is usually indicates when change tracking was enabled, but this value is reset if the table is truncated. 
[Column("begin_version")]
[Nullable]
public long? BeginVersion { get; set; }

Property Value

long?

CleanupVersion

cleanup_version NULL bigint

Version up to which cleanup might have removed change tracking information. 
[Column("cleanup_version")]
[Nullable]
public long? CleanupVersion { get; set; }

Property Value

long?

IsTrackColumnsUpdatedOn

is_track_columns_updated_on NOT NULL bit

Current state of change tracking on the table:

0 = OFF

1 = ON 
[Column("is_track_columns_updated_on")]
[NotNull]
public bool IsTrackColumnsUpdatedOn { get; set; }

Property Value

bool

MinValidVersion

min_valid_version NULL bigint

Minimum valid version of change tracking information that is available for the table.

When obtaining changes from the table that is associated with this row, the value of last_sync_version must be greater than or equal to the version reported by this column. For more information, see CHANGE_TRACKING_MIN_VALID_VERSION (Transact-SQL). 
[Column("min_valid_version")]
[Nullable]
public long? MinValidVersion { get; set; }

Property Value

long?

Object

objects (sys.objects)

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

Property Value

ObjectSchema.Object

ObjectID

object_id NOT NULL int

ID of a table that has a change journal. The table can have a change journal even if change tracking is currently off.

The table ID is unique within the database. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int