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.
|