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
GO
SELECT s.name as Schema_name, t.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

tables_CT_enabled

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="">