Edit

Change Tracking Catalog Views - sys.change_tracking_tables

  • Article

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.

Column name Data type Description
object_id 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.
is_track_columns_updated_on bit Current state of change tracking on the table:

0 = OFF

1 = ON
begin_version 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.
cleanup_version bigint Version up to which cleanup might have removed change tracking information.
min_valid_version 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).

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.

See Also

CHANGE_TRACKING_MIN_VALID_VERSION (Transact-SQL)
Change Tracking Catalog Views (Transact-SQL)
Track Data Changes (SQL Server)