sys.sp_cdc_get_ddl_history

Description

Returns the data definition language (DDL) change history associated with the specified capture instance since change data capture was enabled for that capture instance. Change data capture isn’t available in every edition of SQL Server. For a list of features that are supported by the editions of SQL Server, see Editions and supported features of SQL Server 2022 The name of the capture instance associated with a source table.

Syntax

sys.sp_cdc_get_ddl_history [ @capture_instance = ]
'capture_instance'
[ ; ]