Object type: Table

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

Columns 

Name	Data type	Nullable	Description
DatabaseLogID	int	No	Column has identity seed value of 1 with a step value of 1. Primary key for DatabaseLog records.
PostTime	datetime	No	The date and time the DDL change occurred.
DatabaseUser	sysname	No	The user who implemented the DDL change.
Event	sysname	No	The type of DDL statement that was executed.
Schema	sysname	Yes	The schema to which the changed object belongs.
Object	sysname	Yes	The object that was changed by the DDL statment.
TSQL	nvarchar(max)	No	The exact Transact-SQL statement that was executed.
XmlEvent	xml	No	The raw XML data generated by database trigger.

Modified by 

Name	Description
ddlDatabaseTriggerLog

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation