DatabaseLog Table (AdventureWorks)
Records all data definition language (DDL) statements made to the database over time. The table is populated by a DDL trigger that fires every time a DDL statement is executed. For example, if a user created a new index or modified a table column, the occurrence of that event, including the exact Transact-SQL statement executed, is stored in the DatabaseLog table.
The DatabaseLog table is contained in the dbo schema.
Primary key for DatabaseLog rows.
Date and time the DDL statement was executed.
Name of the user who executed the statement.
Type of event executed. For example, CREATE TABLE or ALTER INDEX.
The schema that owns the modified object.
The modified object.
The Transact-SQL statement that was executed.
The event data captured by the DDL trigger including the server name, logon name, and SPID.