In SQL Server, the Change Data Capture (CDC) feature is primarily designed to capture data changes (DML operations) rather than DDL operations. While CDC can capture certain DDL operations, it has limitations and may not capture all DDL operations.

As @Nick mentioned, you can use DDL triggers to capture DDL events and perform custom actions in response to those events.

CREATE TABLE DDL_Log (
    EventDate DATETIME,
    EventType NVARCHAR(100),
    ObjectName NVARCHAR(100),
    SQLCommand NVARCHAR(MAX)
);

CREATE TRIGGER CaptureDDL
ON DATABASE
FOR ALTER_TABLE
AS
BEGIN
    DECLARE @EventData XML;
    SET @EventData = EVENTDATA();

    DECLARE @EventDate DATETIME = GETDATE();
    DECLARE @EventType NVARCHAR(100) = @EventData.value('(/EVENT_INSTANCE/EventType)[1]', 'NVARCHAR(100)');
    DECLARE @ObjectName NVARCHAR(100) = @EventData.value('(/EVENT_INSTANCE/ObjectName)[1]', 'NVARCHAR(100)');
    DECLARE @SQLCommand NVARCHAR(MAX) = @EventData.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'NVARCHAR(MAX)');

    
    INSERT INTO DDL_Log (EventDate, EventType, ObjectName, SQLCommand)
    VALUES (@EventDate, @EventType, @ObjectName, @SQLCommand);
END;