dbo.DatabaseLog

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 Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
DatabaseLogID	int identity		int		Not null	Primary key for DatabaseLog records.
PostTime	datetime				Not null	The date and time the DDL change occurred.
DatabaseUser	sysname	128	nvarchar(128)		Not null	The user who implemented the DDL change.
Event	sysname	128	nvarchar(128)		Not null	The type of DDL statement that was executed.
Schema	sysname	128	nvarchar(128)		Null	The schema to which the changed object belongs.
Object	sysname	128	nvarchar(128)		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.

Extended Properties

The object has no extended properties.

Primary key for table 'dbo.DatabaseLog'

Primary Key Name	Field Name
PK_DatabaseLog_DatabaseLogID	DatabaseLogID

There are no Foreign Keys for this table.

Indexes for table 'dbo.DatabaseLog', 1 item

Index Name	Description	Clustered	Unique	Fields
PK_DatabaseLog_DatabaseLogID	Nonclustered index created by a primary key constraint.	No	Yes	DatabaseLogID

There are no Triggers for this table.
There are no Dependencies for this object.