dbo.DatabaseLog - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	dbo
Name	DatabaseLog
Module	Admin

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

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		DatabaseLogID	int		Identity		Primary key for DatabaseLog records.
Primary key for DatabaseLog records. Identity
	2		PostTime	datetime				The date and time the DDL change occurred.
The date and time the DDL change occurred.
	3		DatabaseUser	nvarchar(128)				The user who implemented the DDL change.
The user who implemented the DDL change.
	4		Event	nvarchar(128)				The type of DDL statement that was executed.
The type of DDL statement that was executed.
	5		Schema	nvarchar(128)				The schema to which the changed object belongs.
The schema to which the changed object belongs.
	6		Object	nvarchar(128)				The object that was changed by the DDL statment.
The object that was changed by the DDL statment.
	7		TSQL	nvarchar(MAX)				The exact Transact-SQL statement that was executed.
The exact Transact-SQL statement that was executed.
	8		XmlEvent	xml				The raw XML data generated by database trigger.
The raw XML data generated by database trigger.

Unique keys

	Key name	Columns	Description
	PK_DatabaseLog_DatabaseLogID	DatabaseLogID	Primary key (nonclustered) constraint
Primary key (nonclustered) constraint

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56