Class ChangeTrackingSchema.ChangeTrackingDatabase
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
Change Tracking Catalog Views - sys.change_tracking_databases
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Returns one row for each database that has change tracking enabled.
[Table(Schema = "sys", Name = "change_tracking_databases", IsView = true)]
public class ChangeTrackingSchema.ChangeTrackingDatabase- Inheritance
-
ChangeTrackingSchema.ChangeTrackingDatabase
- Extension Methods
Properties
DatabaseID
ID of the database. This is unique within the instance of SQL Server.
[Column("database_id")]
[NotNull]
public int DatabaseID { get; set; }Property Value
IsAutoCleanupOn
Indicates whether change tracking data is automatically cleaned up after the configured retention period:
0 = Off
1 = On
[Column("is_auto_cleanup_on")]
[Nullable]
public bool? IsAutoCleanupOn { get; set; }Property Value
- bool?
RetentionPeriod
If autocleanup is being used, the retention period specifies how long the change tracking data is kept in the database.
[Column("retention_period")]
[Nullable]
public int? RetentionPeriod { get; set; }Property Value
- int?
RetentionPeriodUnits
Unit of time for the retention period:
1 = Minutes
2 = Hours
3 = Days
[Column("retention_period_units")]
[Nullable]
public byte? RetentionPeriodUnits { get; set; }Property Value
- byte?
RetentionPeriodUnitsDesc
Specifies the description of the retention period:
Minutes
Hours
Days
[Column("retention_period_units_desc")]
[Nullable]
public string? RetentionPeriodUnitsDesc { get; set; }