Table: [AdventureWorks2016CTP3].[dbo].[AUDIT_LOG_TRANSACTIONS]

CollapseAll image

Collapse image Table properties


Name  Value 
 Schema  [dbo]
 Owner  [dbo]
 Table is replicated   
 Creation date  21.09.2016
 ID  1099866985
 Located on  PRIMARY
 Data size KB  0 KB
 Index size KB  0 KB
 Rows  0
 ChangeTrackingEnabled   
 FileStreamFileGroup   
 FileStreamPartitionScheme   
 LockEscalation  TABLE
 TrackColumnsUpdatedEnabled   
 Table is filetable   
 Filetable directory   
 Filetable collate   
 Filetable primary key  [PK__AUDIT_LO__EC2FB09B1A76BC40]
 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 AUDIT_LOG_TRANSACTION_ID     int 4        
    DATABASE     nvarchar 128   (db_name())    
    TABLE_NAME     nvarchar 261        
    TABLE_SCHEMA     nvarchar 261        
    AUDIT_ACTION_ID     tinyint 1        
    HOST_NAME     varchar 128        
    APP_NAME     varchar 128        
    MODIFIED_BY     varchar 128        
    MODIFIED_DATE     datetime 8        
    AFFECTED_ROWS     int 4        
    SYSOBJ_ID   True int 4       (object_id([TABLE_NAME]))
Total: 11 column(s)

Collapse image Indexes


Index  Description  Primary  Unique  Size KB 
[PK__AUDIT_LO__EC2FB09B1A76BC40] AUDIT_LOG_TRANSACTION_ID   0 0
[IDX1_AUDIT_LOG_TRANSACTIONS] TABLE_NAME       0 0
[IDX2_AUDIT_LOG_TRANSACTIONS] MODIFIED_DATE       0 0
[IDX3_AUDIT_LOG_TRANSACTIONS] MODIFIED_BY       0 0
[IDX4_AUDIT_LOG_TRANSACTIONS] HOST_NAME       0 0
Total: 5 Index/indexes

Collapse image Columnstore indexes


No columnstore indexes exist

Collapse image Identity column


  Name  Seed  Increment  Not for replication 
 AUDIT_LOG_TRANSACTION_ID   1   1   

Collapse image Referencing tables


Table  Foreign key  Primary key or unique constraint 
[dbo].[AUDIT_LOG_DATA] FK_AUDIT_LOG_TRANSACTION_ID PK__AUDIT_LO__EC2FB09B1A76BC40
Total: 1 table(s)

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


Object name Object type Dep level
[dbo].[AUDIT_prc_DeleteArchitecture] Procedure 1
[dbo].[AUDIT_prc_Purge_AUDIT_LOG] Procedure 1
[dbo].[AUDIT_LOG_DATA] Table 1
[dbo].[tr_d_AUDIT_AWBuildVersion] Trigger 1
[dbo].[tr_d_AUDIT_DatabaseLog] Trigger 1
[HumanResources].[tr_d_AUDIT_Department] Trigger 1
[HumanResources].[tr_d_AUDIT_Employee] Trigger 1
[HumanResources].[tr_d_AUDIT_EmployeeDepartmentHistory] Trigger 1
[HumanResources].[tr_d_AUDIT_EmployeePayHistory] Trigger 1
[dbo].[tr_d_AUDIT_ErrorLog] Trigger 1
[dbo].[tr_i_AUDIT_DatabaseLog] Trigger 1
[HumanResources].[tr_i_AUDIT_Department] Trigger 1
[HumanResources].[tr_i_AUDIT_Employee] Trigger 1
[HumanResources].[tr_i_AUDIT_EmployeeDepartmentHistory] Trigger 1
[HumanResources].[tr_i_AUDIT_EmployeePayHistory] Trigger 1
[dbo].[tr_i_AUDIT_ErrorLog] Trigger 1
[dbo].[tr_u_AUDIT_AWBuildVersion] Trigger 1
[dbo].[tr_u_AUDIT_DatabaseLog] Trigger 1
[HumanResources].[tr_u_AUDIT_Department] Trigger 1
[HumanResources].[tr_u_AUDIT_Employee_Temporal] Trigger 1
[HumanResources].[tr_u_AUDIT_EmployeeDepartmentHistory] Trigger 1
[HumanResources].[tr_u_AUDIT_EmployeePayHistory] Trigger 1
[dbo].[AUDIT_UNDO] View 1
[dbo].[AUDIT_VIEW] View 1
Total 24 object(s)

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].[AUDIT_LOG_TRANSACTIONS] (
        [AUDIT_LOG_TRANSACTION_ID]     [int] IDENTITY(1, 1) NOT NULL,
        [DATABASE]                     [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [TABLE_NAME]                   [nvarchar](261) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [TABLE_SCHEMA]                 [nvarchar](261) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [AUDIT_ACTION_ID]              [tinyint] NOT NULL,
        [HOST_NAME]                    [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [APP_NAME]                     [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [MODIFIED_BY]                  [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [MODIFIED_DATE]                [datetime] NOT NULL,
        [AFFECTED_ROWS]                [int] NOT NULL,
        [SYSOBJ_ID]                    AS (object_id([TABLE_NAME])),
        CONSTRAINT [PK__AUDIT_LO__EC2FB09B1A76BC40]
        PRIMARY KEY
        CLUSTERED
        ([AUDIT_LOG_TRANSACTION_ID])
    ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AUDIT_LOG_TRANSACTIONS]
    ADD
    CONSTRAINT [DF__AUDIT_LOG__DATAB__4376EBDB]
    DEFAULT (db_name()) FOR [DATABASE]
GO
CREATE NONCLUSTERED INDEX [IDX1_AUDIT_LOG_TRANSACTIONS]
    ON [dbo].[AUDIT_LOG_TRANSACTIONS] ([TABLE_NAME], [AUDIT_ACTION_ID])
    ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IDX2_AUDIT_LOG_TRANSACTIONS]
    ON [dbo].[AUDIT_LOG_TRANSACTIONS] ([MODIFIED_DATE])
    ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IDX3_AUDIT_LOG_TRANSACTIONS]
    ON [dbo].[AUDIT_LOG_TRANSACTIONS] ([MODIFIED_BY])
    ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IDX4_AUDIT_LOG_TRANSACTIONS]
    ON [dbo].[AUDIT_LOG_TRANSACTIONS] ([HOST_NAME])
    ON [PRIMARY]
GO

Collapse image See also


List of tables