| title | Change Data Capture Tables (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/06/2017 | |
| ms.prod | sql-non-specified | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | a4372d0b-50ca-4e58-80f6-2ed3cb52a84a | |
| caps.latest.revision | 14 | |
| author | BYHAM | |
| ms.author | rickbyh | |
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Change data capture enables change tracking on tables so that data manipulation language (DML) and data definition language (DDL) changes made to the tables can be incrementally loaded into a data warehouse. The topics in this section describe the system tables that store information used by change data capture operations.
cdc.<capture_instance>_CT
Returns one row for each change made to a captured column in the associated source table.
cdc.captured_columns
Returns one row for each column tracked in a capture instance.
cdc.change_tables
Returns one row for each change table in the database.
cdc.ddl_history
Returns one row for each data definition language (DDL) change made to tables that are enabled for change data capture.
cdc.lsn_time_mapping
Returns one row for each transaction having rows in a change table. This table is used to map between log sequence number (LSN) commit values and the time the transaction committed.
cdc.index_columns
Returns one row for each index column associated with a change table.
dbo.cdc_jobs (Transact-SQL)
Returns the configuration parameters for change data capture agent jobs.
Change Data Capture Stored Procedures (Transact-SQL)
Change Data Capture Functions (Transact-SQL)