cdc-index-columns-transact-sql.md

title	cdc.index_columns (Transact-SQL)
description	cdc.index_columns (Transact-SQL)
author	VanMSFT
ms.author	vanto
ms.date	02/22/2023
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	cdc.index_columns_TSQL cdc.index_columns
helpviewer_keywords	cdc.index_columns
dev_langs	TSQL

cdc.index_columns (Transact-SQL)

[!INCLUDE SQL Server]

Returns one row for each index column associated with a change table. The index columns are used by change data capture to uniquely identify rows in the source table. By default, the columns of the primary key of the source table are included. However, if a unique index on the source table is specified when change data capture is enabled on the source table, columns in that index are used instead. A primary key or unique index is required on the source table if net change tracking is enabled. For more information, see sys.sp_cdc_enable_table (Transact-SQL).

We recommend that you don't query the system tables directly. Instead, execute the sys.sp_cdc_help_change_data_capture stored procedure.

Column name	Data type	Description
object_id	int	ID of the change table.
column_name	sysname	Name of the index column.
index_ordinal	tinyint	Ordinal (one-based) of the column within the index.
column_id	int	ID of the column in the source table.

See Also

cdc.change_tables (Transact-SQL)