Dbo.DatabaseLog (table)

wikibot

Table

dbo.DatabaseLog

Column	Data Type	Nullable	Default	PK	Index
DatabaseLogID	int	not null		PK_DatabaseLog_DatabaseLogID
PostTime	datetime	not null
DatabaseUser	sysname	not null
Event	sysname	not null
Schema	sysname	null
Object	sysname	null
TSQL	nvarchar(max)	not null
XmlEvent	xml	not null

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