Share via


DatabaseLog Table (AdventureWorks)

Records all data definition language (DDL) statements made to the database over time. The table is populated by a DDL trigger that fires every time a DDL statement is executed. For example, if a user created a new index or modified a table column, the occurrence of that event, including the exact Transact-SQL statement executed, is stored in the DatabaseLog table.

DatabaseLog Table Definition

The DatabaseLog table is contained in the dbo schema.

Column Data type Nullability Description

DatabaseLogID

int

Not null

Primary key for DatabaseLog rows.

PostTime

datetime

Not null

Date and time the DDL statement was executed.

DatabaseUser

sysname

Not null

Name of the user who executed the statement.

Event

sysname

Not null

Type of event executed. For example, CREATE TABLE or ALTER INDEX.

Schema

sysname

Null

The schema that owns the modified object.

Object

sysname

Null

The modified object.

TSQL

nvarchar(max)

Not null

The Transact-SQL statement that was executed.

XmlEvent

xml

Not null

The event data captured by the DDL trigger including the server name, logon name, and SPID.

See Also

Other Resources

AdventureWorks Data Dictionary
DDL Triggers

Help and Information

Getting SQL Server 2005 Assistance