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

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	dev_langs
Change Data Capture Functions (Transact-SQL)	Change Data Capture Functions (Transact-SQL)	rwestMSFT	randolphwest	03/14/2017	sql	system-objects	reference	change data capture [SQL Server], functions	TSQL

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)