List all Tables that have Change Tracking (CT) enabled on a SQL Server Database

Change Tracking (CT) feature was introduced in SQL Server 2008, and is used to get the rows in user tables that have changed, without the data that was changed. You can get the latest data directly from the tracked table.

To list all tables that have Change Tracking (CT) enabled on a SQL Server database, use the following query:

USE Database_Name
SELECT as Schema_name, AS Table_name, tr.*
FROM sys.change_tracking_tables tr
INNER JOIN sys.tables t on t.object_id = tr.object_id
INNER JOIN sys.schemas s on s.schema_id = t.schema_id


You will get one row for each table that has Change Tracking enabled in the current database.

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">