Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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