SQL Server EVENTDATA () function to obtain DDL trigger information

Copy codeThe Code is as follows:
-- Create a log table
Create table TriggerLog (LogInfo xml)

-- Create a dummy table to delete later on
Create table TableToDelete (Id int primary key)

-- Create a new table to delete the experiment table.
Insert into TableToDelete VALUES (1)
GO

-- Create a Drop Table DDL
Create trigger StopTableDrop on database after DROP_TABLE
AS
DECLARE @ EventData AS xml
SET @ EventData = EVENTDATA () -- DDL information must be intercepted before rollback.
ROLLBACK
PRINT 'drop TABLE attempt in database' + DB_NAME () + '.'
Insert into TriggerLog VALUES (@ EventData)

Perform the following delete operation:
Drop table TableToDelete
Will trigger the above DDL to roll back the operation.
Execute the following SQL:
SELECT * FROM TriggerLog
View the intercepted DDL information.