AdventureWorks

Basic Index   Expanded Index

Table Name:dbo.DatabaseLog
Description:Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
Primary Keys:DatabaseLogID
FieldTypeDefaultsNulls?Comments
DatabaseLogIDint - IdentityNoneNoPrimary key for DatabaseLog records.
PostTimedatetimeNoneNoThe date and time the DDL change occurred.
DatabaseUsernvarchar (128)NoneNoThe user who implemented the DDL change.
Eventnvarchar (128)NoneNoThe type of DDL statement that was executed.
Schemanvarchar (128)NoneYesThe schema to which the changed object belongs.
Objectnvarchar (128)NoneYesThe object that was changed by the DDL statment.
TSQLnvarchar (MAX)NoneNoThe exact Transact-SQL statement that was executed.
XmlEventxmlNoneNoThe raw XML data generated by database trigger.

IndexClustered?Unique?Fields
PK_DatabaseLog_DatabaseLogIDNoYesDatabaseLogID

No check constraints
No internal foreign key constraints
No primary keys as foreign key constraints
No triggers