Difference between revisions of "Dbo.DatabaseLog (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | dbo.DatabaseLog |- |} {| border="1" cellpadding="5" cellspacing="0" style="b...)
 
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== 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"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 100:
 
| '''Table
 
| '''Table
 
| dbo.DatabaseLog
 
| dbo.DatabaseLog
 +
|- valign="top"
 +
| '''Description
 +
| Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 113:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| DatabaseLogID
 
| DatabaseLogID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_DatabaseLog_DatabaseLogID
+
| Primary key for DatabaseLog records.<br />PK_DatabaseLog_DatabaseLogID
−
|
+
|- valign="top"
−
|-
 
 
| PostTime
 
| PostTime
 
| datetime
 
| datetime
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| The date and time the DDL change occurred.<br />
−
|
+
|- valign="top"
−
|-
 
 
| DatabaseUser
 
| DatabaseUser
 
| sysname
 
| sysname
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| The user who implemented the DDL change.<br />
−
|
+
|- valign="top"
−
|-
 
 
| Event
 
| Event
 
| sysname
 
| sysname
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| The type of DDL statement that was executed.<br />
−
|
+
|- valign="top"
−
|-
 
 
| Schema
 
| Schema
 
| sysname
 
| sysname
 
| null
 
| null
 
|  
 
|  
−
|  
+
| The schema to which the changed object belongs.<br />
−
|
+
|- valign="top"
−
|-
 
 
| Object
 
| Object
 
| sysname
 
| sysname
 
| null
 
| null
 
|  
 
|  
−
|  
+
| The object that was changed by the DDL statment.<br />
−
|
+
|- valign="top"
−
|-
 
 
| TSQL
 
| TSQL
 
| nvarchar(max)
 
| nvarchar(max)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| The exact Transact-SQL statement that was executed.<br />
−
|
+
|- valign="top"
−
|-
 
 
| XmlEvent
 
| XmlEvent
 
| xml
 
| xml
 
| not null
 
| 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]]
 +
 
 
|}
 
|}

Latest revision as of 23:15, 23 June 2010

wikibot[edit]

Table dbo.DatabaseLog
Description Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.

Columns[edit]

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.

Primary Key[edit]

Primary Key Columns
PK_DatabaseLog_DatabaseLogID DatabaseLogID

Dependencies[edit]

Reference Type Object Type Referencing Object
Insert Database Trigger ddlDatabaseTriggerLog


automatically generated[edit]

Table dbo.DatabaseLog
Description Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.


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.


Reference Type Object Type Referencing Object
Insert Database Trigger ddlDatabaseTriggerLog
Retrieved from "http://dbshelp.devio.at/index.php?title=Dbo.DatabaseLog_(table)&oldid=2575"