title: "sys.change_tracking_databases (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "08/08/2016" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "change_tracking_databases"
- "sys.change_tracking_databases_TSQL"
- "sys.change_tracking_databases"
- "change_tracking_databases_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.change_tracking_databases"
- "change tracking [SQL Server], sys.change_tracking_databases" ms.assetid: bb233baa-2991-4904-a0eb-3772b81121a4 caps.latest.revision: 17 author: "edmacauley" ms.author: "edmaca" manager: "craigg" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md]
Returns one row for each database that has change tracking enabled.
| Column name | Data type | Description |
|---|---|---|
| database_id | int | ID of the database. This is unique within the instance of [!INCLUDEssNoVersion]. |
| is_auto_cleanup_on | bit | Indicates whether change tracking data is automatically cleaned up after the configured retention period: 0 = Off 1 = On |
| retention_period | int | If autocleanup is being used, the retention period specifies how long the change tracking data is kept in the database. |
| retention_period_units_desc | nvarchar(60) | Specifies the description of the retention period: Minutes Hours Days |
| retention_period_units | tinyint | Unit of time for the retention period: 1 = Minutes 2 = Hours 3 = Days |
The same permission checks are made for sys.change_tracking_databases as are made for sys.databases. If the caller of sys.change_tracking_databases is not the owner of the database, the minimum permissions that are required to see the corresponding row are ALTER ANY DATABASE or VIEW ANY DATABASE server-level permission, or CREATE DATABASE permission in the master database or current database.
Change Tracking Catalog Views (Transact-SQL)
Track Data Changes (SQL Server)