Owner: dbo 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 1408 
Index Size KB: 24 
Rows: 389 
Description: Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    DatabaseLogID  int          Primary key for DatabaseLog records. 
    PostTime  datetime          The date and time the DDL change occurred. 
    DatabaseUser  sysname  256          The user who implemented the DDL change. 
    Event  sysname  256          The type of DDL statement that was executed. 
    Schema  sysname  256          The schema to which the changed object belongs. 
    Object  sysname  256          The object that was changed by the DDL statment. 
    TSQL  nvarchar  -0.5          The exact Transact-SQL statement that was executed. 
    XmlEvent  xml  -1          The raw XML data generated by database trigger. 
Total: 8 column(s)

Identity column

Name Seed Increment Not for replication


Index Primary Unique Description
  PK_DatabaseLog_DatabaseLogID      Primary key (nonclustered) constraint 
Total: 1 index(es)


CREATE TABLE [DatabaseLog] (
    [DatabaseLogID] [int] IDENTITY (1, 1) NOT NULL ,
    [PostTime] [datetime] NOT NULL ,
    [DatabaseUser] [sysname] NOT NULL ,
    [Event] [sysname] NOT NULL ,
    [Schema] [sysname] NULL ,
    [Object] [sysname] NULL ,
    [TSQL] [nvarchar] (0) COLLATE Latin1_General_CS_AS NOT NULL ,
    [XmlEvent] [xml] NOT NULL ,
    )  ON [PRIMARY]

See Also

List of tables