Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
|1||DatabaseLogID||int||Identity||Primary key for DatabaseLog records.|
|Primary key for DatabaseLog records.
|2||PostTime||datetime||The date and time the DDL change occurred.|
|The date and time the DDL change occurred.
|3||DatabaseUser||nvarchar(128)||The user who implemented the DDL change.|
|The user who implemented the DDL change.
|4||Event||nvarchar(128)||The type of DDL statement that was executed.|
|The type of DDL statement that was executed.
|5||Schema||nvarchar(128)||The schema to which the changed object belongs.|
|The schema to which the changed object belongs.
|6||Object||nvarchar(128)||The object that was changed by the DDL statment.|
|The object that was changed by the DDL statment.
|7||TSQL||nvarchar(MAX)||The exact Transact-SQL statement that was executed.|
|The exact Transact-SQL statement that was executed.
|8||XmlEvent||xml||The raw XML data generated by database trigger.|
|The raw XML data generated by database trigger.
|PK_DatabaseLog_DatabaseLogID||DatabaseLogID||Primary key (nonclustered) constraint|
|Primary key (nonclustered) constraint|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56