cdc.ddl_history (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
Returns one row for each data definition language (DDL) change made to tables that are enabled for change data capture. You can use this table to determine when a DDL change occurred on a source table and what the change was. Source tables that haven't had DDL changes won't have entries in this table.
We recommend that you don't query the system tables directly. Instead, execute the sys.sp_cdc_get_ddl_history stored procedure.
Column name | Data type | Description |
---|---|---|
source_object_id | int | ID of the source table to which the DDL change was applied. |
object_id | int | ID of the change table associated with a capture instance for the source table. |
required_column_update | bit | Indicates that the data type of a captured column was modified in the source table. This modification altered the column in the change table. |
ddl_command | nvarchar(max) | DDL statement applied to the source table. |
ddl_lsn | binary(10) | Log sequence number (LSN) associated with the commitment of the DDL modification. |
ddl_time | datetime | Date and time that the DDL change was made to the source table. |
See Also
sys.sp_cdc_help_change_data_capture (Transact-SQL)
cdc.fn_cdc_get_all_changes_<capture_instance> (Transact-SQL)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho