Table: 'dbo.DatabaseLog'

8 fields. 1044 bytes.

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

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
DatabaseLogIDint identity int Not nullPrimary key for DatabaseLog records. 
PostTimedatetime   Not nullThe date and time the DDL change occurred. 
DatabaseUsersysname128nvarchar(128) Not nullThe user who implemented the DDL change. 
Eventsysname128nvarchar(128) Not nullThe type of DDL statement that was executed. 
Schemasysname128nvarchar(128) NullThe schema to which the changed object belongs. 
Objectsysname128nvarchar(128) NullThe object that was changed by the DDL statment. 
TSQLnvarcharmax  Not nullThe exact Transact-SQL statement that was executed. 
XmlEventxml   Not nullThe raw XML data generated by database trigger. 

Extended Properties

The object has no extended properties.

Primary key for table 'dbo.DatabaseLog'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'dbo.DatabaseLog', 1 item

Index NameDescriptionClusteredUniqueFields
PK_DatabaseLog_DatabaseLogIDNonclustered index created by a primary key constraint.NoYesDatabaseLogID
There are no Triggers for this table.
There are no Dependencies for this object.