Dbo.DatabaseLog (table)

wikibot

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

Columns

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

Primary Key	Columns
PK_DatabaseLog_DatabaseLogID	DatabaseLogID

Dependencies

Reference Type	Object Type	Referencing Object
Insert	Database Trigger	ddlDatabaseTriggerLog

automatically generated

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