Table: [AdventureWorks2016CTP3].[dbo].[AUDIT_LOG_DATA]

CollapseAll image

Collapse image Table properties


Name  Value 
 Schema  [dbo]
 Owner  [dbo]
 Table is replicated   
 Creation date  21.09.2016
 ID  1147867156
 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__40D2552DE38D4F0A]
 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_DATA_ID     int 4        
    Foreign key AUDIT_LOG_TRANSACTION_ID     int 4        
      PRIMARY_KEY_DATA     nvarchar 1500        
      COL_NAME     nvarchar 128        
      OLD_VALUE_LONG     ntext 1073741823      
      NEW_VALUE_LONG     ntext 1073741823      
      NEW_VALUE_BLOB     image 2147483647      
      NEW_VALUE   True nvarchar 4000       (isnull(CONVERT([nvarchar](4000),[NEW_VALUE_LONG]),CONVERT([varchar](8000),CONVERT([varbinary](8000),substring([NEW_VALUE_BLOB],(1),(8000))))))
      OLD_VALUE   True nvarchar 4000       (CONVERT([nvarchar](4000),[OLD_VALUE_LONG]))
      PRIMARY_KEY   True nvarchar 1500         ([PRIMARY_KEY_DATA])
      DATA_TYPE     char 1   ('A')    
      KEY1     nvarchar 500      
      KEY2     nvarchar 500      
      KEY3     nvarchar 500      
      KEY4     nvarchar 500      
Total: 15 column(s)

Collapse image Indexes


Index  Description  Primary  Unique  Size KB 
[PK__AUDIT_LO__40D2552DE38D4F0A] AUDIT_LOG_DATA_ID   0 0
[IDX1_AUDIT_LOG_DATA] COL_NAME       0 0
[IDX2_AUDIT_LOG_DATA] AUDIT_LOG_TRANSACTION_ID       0 0
Total: 3 Index/indexes

Collapse image Columnstore indexes


No columnstore indexes exist

Collapse image Identity column


  Name  Seed  Increment  Not for replication 
 AUDIT_LOG_DATA_ID   1   1   

Collapse image Referenced tables


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

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


Object name Object type Dep level
[dbo].[AUDIT_prc_DeleteArchitecture] Procedure 1
[dbo].[AUDIT_prc_Purge_AUDIT_LOG] Procedure 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 23 object(s)

Collapse image Objects that [dbo].[AUDIT_LOG_DATA] depends on


Object name Object type Dep level
[dbo].[AUDIT_LOG_TRANSACTIONS] Table 1
Total 1 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_DATA] (
        [AUDIT_LOG_DATA_ID]            [int] IDENTITY(1, 1) NOT NULL,
        [AUDIT_LOG_TRANSACTION_ID]     [int] NOT NULL,
        [PRIMARY_KEY_DATA]             [nvarchar](1500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [COL_NAME]                     [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [OLD_VALUE_LONG]               [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [NEW_VALUE_LONG]               [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [NEW_VALUE_BLOB]               [image] NULL,
        [NEW_VALUE]                    AS (isnull(CONVERT([nvarchar](4000),[NEW_VALUE_LONG]),CONVERT([varchar](8000),CONVERT([varbinary](8000),substring([NEW_VALUE_BLOB],(1),(8000)))))),
        [OLD_VALUE]                    AS (CONVERT([nvarchar](4000),[OLD_VALUE_LONG])),
        [PRIMARY_KEY]                  AS ([PRIMARY_KEY_DATA]),
        [DATA_TYPE]                    [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [KEY1]                         [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [KEY2]                         [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [KEY3]                         [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [KEY4]                         [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        CONSTRAINT [PK__AUDIT_LO__40D2552DE38D4F0A]
        PRIMARY KEY
        CLUSTERED
        ([AUDIT_LOG_DATA_ID])
    ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[AUDIT_LOG_DATA]
    ADD
    CONSTRAINT [DF__AUDIT_LOG__DATA___46535886]
    DEFAULT ('A') FOR [DATA_TYPE]
GO
ALTER TABLE [dbo].[AUDIT_LOG_DATA]
    WITH CHECK
    ADD CONSTRAINT [FK_AUDIT_LOG_TRANSACTION_ID]
    FOREIGN KEY ([AUDIT_LOG_TRANSACTION_ID]) REFERENCES [dbo].[AUDIT_LOG_TRANSACTIONS] ([AUDIT_LOG_TRANSACTION_ID])
ALTER TABLE [dbo].[AUDIT_LOG_DATA]
    CHECK CONSTRAINT [FK_AUDIT_LOG_TRANSACTION_ID]

GO
CREATE NONCLUSTERED INDEX [IDX1_AUDIT_LOG_DATA]
    ON [dbo].[AUDIT_LOG_DATA] ([COL_NAME])
    ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IDX2_AUDIT_LOG_DATA]
    ON [dbo].[AUDIT_LOG_DATA] ([AUDIT_LOG_TRANSACTION_ID])
    ON [PRIMARY]
GO

Collapse image See also


List of tables