Table: dbo.DatabaseLog

Properties

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.

Columns

Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
DatabaseLogID	int	4					Primary key for DatabaseLog records.
PostTime	datetime	8					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
	DatabaseLogID	1	1

Indexes

	Index	Primary	Unique	Description
	PK_DatabaseLog_DatabaseLogID			Primary key (nonclustered) constraint

Total: 1 index(es)

SQL

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 ,
    CONSTRAINT [PK_DatabaseLog_DatabaseLogID] PRIMARY KEY  NONCLUSTERED
    (
        [DatabaseLogID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO