ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
dbo.DatabaseLog_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | dbo.DatabaseLog |- valign="top" | '''Description''' | Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | DatabaseLogID | int | not null | | Primary key for DatabaseLog records. |- valign="top" | PostTime | datetime | not null | | The date and time the DDL change occurred. |- valign="top" | DatabaseUser | sysname | not null | | The user who implemented the DDL change. |- valign="top" | Event | sysname | not null | | The type of DDL statement that was executed. |- valign="top" | Schema | sysname | null | | The schema to which the changed object belongs. |- valign="top" | Object | sysname | null | | The object that was changed by the DDL statment. |- valign="top" | TSQL | nvarchar(max) | not null | | The exact Transact-SQL statement that was executed. |- valign="top" | XmlEvent | xml | not null | | The raw XML data generated by database trigger. |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PK_DatabaseLog_DatabaseLogID | DatabaseLogID |} === Dependencies === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- valign="top" | Insert | Database Trigger | [[ddlDatabaseTriggerLog_(database trigger)|ddlDatabaseTriggerLog]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | dbo.DatabaseLog |- valign="top" | '''Description''' | Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | DatabaseLogID | int | not null | | Primary key for DatabaseLog records.<br />PK_DatabaseLog_DatabaseLogID |- | PostTime | datetime | not null | | The date and time the DDL change occurred.<br /> |- | DatabaseUser | sysname | not null | | The user who implemented the DDL change.<br /> |- | Event | sysname | not null | | The type of DDL statement that was executed.<br /> |- | Schema | sysname | null | | The schema to which the changed object belongs.<br /> |- | Object | sysname | null | | The object that was changed by the DDL statment.<br /> |- | TSQL | nvarchar(max) | not null | | The exact Transact-SQL statement that was executed.<br /> |- | XmlEvent | xml | not null | | The raw XML data generated by database trigger.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- | Insert | Database Trigger | [[ddlDatabaseTriggerLog_(database_trigger)|ddlDatabaseTriggerLog]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.