change-data-capture-functions-transact-sql.md

description	Change Data Capture Functions (Transact-SQL)
title	Change Data Capture Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	reference
dev_langs	TSQL
helpviewer_keywords	change data capture [SQL Server], functions
ms.assetid	e5270557-aca3-44ab-8715-daccd498b88d
author	rwestMSFT
ms.author	randolphwest

Change Data Capture Functions (Transact-SQL)

[!INCLUDE SQL Server]

Change data capture records insert, update, and delete activity applied to [!INCLUDEssNoVersion] tables, supplying the details of the changes in an easily consumed relational format. Column information that mirrors the column structure of a tracked source table is captured for the modified rows, along with the metadata needed to apply the changes to a target environment. The following functions are used to return information about the changes.

:::row::: :::column::: cdc.fn_cdc_get_all_changes_<capture_instance> (Transact-SQL) :::column-end::: :::column::: sys.fn_cdc_has_column_changed (Transact-SQL) :::column-end::: :::row-end:::
:::row::: :::column::: cdc.fn_cdc_get_net_changes_<capture_instance> (Transact-SQL) :::column-end::: :::column::: sys.fn_cdc_increment_lsn (Transact-SQL) :::column-end::: :::row-end:::
:::row::: :::column::: sys.fn_cdc_decrement_lsn (Transact-SQL) :::column-end::: :::column::: sys.fn_cdc_is_bit_set (Transact-SQL) :::column-end::: :::row-end:::
:::row::: :::column::: sys.fn_cdc_get_column_ordinal (Transact-SQL) :::column-end::: :::column::: sys.fn_cdc_map_lsn_to_time (Transact-SQL) :::column-end::: :::row-end:::
:::row::: :::column::: sys.fn_cdc_get_max_lsn (Transact-SQL) :::column-end::: :::column::: sys.fn_cdc_map_time_to_lsn (Transact-SQL) :::column-end::: :::row-end:::
:::row::: :::column::: sys.fn_cdc_get_min_lsn (Transact-SQL) :::column-end::: :::column::: :::column-end::: :::row-end:::

See Also

Change Data Capture Tables (Transact-SQL)
Change Data Capture Stored Procedures (Transact-SQL)
About Change Data Capture (SQL Server)