dbo DatabaseLog (table)


DescriptionAudit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.


ColumnData TypeNullableDefaultDescription
DatabaseLogIDintnot null Primary key for DatabaseLog records.
PostTimedatetimenot null The date and time the DDL change occurred.
DatabaseUsersysnamenot null The user who implemented the DDL change.
Eventsysnamenot null The type of DDL statement that was executed.
Schemasysnamenull The schema to which the changed object belongs.
Objectsysnamenull The object that was changed by the DDL statment.
TSQLnvarchar(max)not null The exact Transact-SQL statement that was executed.
XmlEventxmlnot null The raw XML data generated by database trigger.

Primary Key

Primary KeyColumns


Reference TypeObject TypeReferencing Object
InsertDatabase TriggerddlDatabaseTriggerLog