Column | Data Type | Nullable | Default | Description |
DatabaseLogID | int | not null | | Primary key for DatabaseLog records. |
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. |