Dbo.DatabaseLog (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

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

Columns[edit]

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

Primary Key[edit]

Primary Key Columns
PK_DatabaseLog_DatabaseLogID DatabaseLogID

Dependencies[edit]

Reference Type Object Type Referencing Object
Insert Database Trigger ddlDatabaseTriggerLog


automatically generated[edit]

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


Column Data Type Nullable Default Description / PK / Index
DatabaseLogID int not null Primary key for DatabaseLog records.
PK_DatabaseLog_DatabaseLogID
PostTime datetime not null The date and time the DDL change occurred.
DatabaseUser sysname not null The user who implemented the DDL change.
Event sysname not null The type of DDL statement that was executed.
Schema sysname null The schema to which the changed object belongs.
Object sysname null The object that was changed by the DDL statment.
TSQL nvarchar(max) not null The exact Transact-SQL statement that was executed.
XmlEvent xml not null The raw XML data generated by database trigger.


Reference Type Object Type Referencing Object
Insert Database Trigger ddlDatabaseTriggerLog