Table: [AdventureWorks2016CTP3].[dbo].[DatabaseLog]

CollapseAll image

Collapse image Table properties


Name  Value 
 Schema  [dbo]
 Owner  [dbo]
 Table is replicated   
 Creation date  23.10.2015
 ID  565577053
 Located on  PRIMARY
 Data size KB  808 KB
 Index size KB  24 KB
 Rows  179
 ChangeTrackingEnabled   
 FileStreamFileGroup   
 FileStreamPartitionScheme   
 LockEscalation  TABLE
 TrackColumnsUpdatedEnabled   
 Table is filetable   
 Filetable directory   
 Filetable collate   
 Filetable primary key  [PK_DatabaseLog_DatabaseLogID]
 Filetable streamid unique   
 Filetable fullpath unique   
 Filetable is enabled   
 Is memory optimized   
 Durability  SCHEMA_AND_DATA

Collapse image Creation options


Name  Value 
QUOTED_IDENTIFIER ON
ANSI_NULLS ON
ANSI_PADDING ON

Collapse image Columns


    Name  Description  Data type  Max length  Nullable  Default IsGUID  SPARSE Computed value
Primary key Identity DatabaseLogID     int 4        
    PostTime     datetime 8        
    DatabaseUser     sysname 128        
    Event     sysname 128        
    Schema     sysname 128      
    Object     sysname 128      
    TSQL     nvarchar 1073741823        
    XmlEvent     xml 2147483647        
Total: 8 column(s)

Collapse image Indexes


Index  Description  Primary  Unique  Size KB 
[PK_DatabaseLog_DatabaseLogID] DatabaseLogID   16 0
Total: 1 Index/indexes

Collapse image Columnstore indexes


No columnstore indexes exist

Collapse image Identity column


  Name  Seed  Increment  Not for replication 
 DatabaseLogID   1   1   

Collapse image Triggers


Name  Schema  Description  Instead 
of 
For 
insert 
For 
update 
For 
delete 
Table/view 
[dbo].[tr_i_AUDIT_DatabaseLog] [dbo]     For Insert     [dbo].[DatabaseLog]
[dbo].[tr_u_AUDIT_DatabaseLog] [dbo]       For Update   [dbo].[DatabaseLog]
[dbo].[tr_d_AUDIT_DatabaseLog] [dbo]         For Delete [dbo].[DatabaseLog]
Total: 3 triggers(s)

Collapse image Objects that depend on [dbo].[DatabaseLog]


Object name Object type Dep level
[dbo].[tr_d_AUDIT_DatabaseLog] Trigger 1
[dbo].[tr_i_AUDIT_DatabaseLog] Trigger 1
[dbo].[tr_u_AUDIT_DatabaseLog] Trigger 1
Total 3 object(s)

Collapse image Extended properties


Name  Value 
MS_Description Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.

Collapse image Table options


Name  Value 
Pintable OFF
Table lock on bulk load OFF
Insert row lock OFF
Text in row 0
Large value types out of row OFF

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DatabaseLog] (
        [DatabaseLogID]     [int] IDENTITY(1, 1) NOT NULL,
        [PostTime]          [datetime] NOT NULL,
        [DatabaseUser]      [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [Event]             [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [Schema]            [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Object]            [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [TSQL]              [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [XmlEvent]          [xml] NOT NULL,
        CONSTRAINT [PK_DatabaseLog_DatabaseLogID]
        PRIMARY KEY
        NONCLUSTERED
        ([DatabaseLogID])
    ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key (nonclustered) constraint', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'CONSTRAINT', N'PK_DatabaseLog_DatabaseLogID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Nonclustered index created by a primary key constraint.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'INDEX', N'PK_DatabaseLog_DatabaseLogID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key for DatabaseLog records.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'DatabaseLogID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The user who implemented the DDL change.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'DatabaseUser'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The type of DDL statement that was executed.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'Event'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The object that was changed by the DDL statment.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'Object'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The date and time the DDL change occurred.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'PostTime'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The schema to which the changed object belongs.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'Schema'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The exact Transact-SQL statement that was executed.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'TSQL'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The raw XML data generated by database trigger.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'XmlEvent'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', NULL, NULL
GO

Collapse image See also


List of tables