Export (0) Print
Expand All

sys.change_tracking_tables (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type




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.



Current state of change tracking on the table:

0 = OFF

1 = ON



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.



Version up to which cleanup might have removed change tracking information.



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).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft