Table:
[AdventureWorks2016CTP3].[dbo].[AUDIT_LOG_DATA]
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 |
Creation options
| Name | Value |
| QUOTED_IDENTIFIER | ON |
| ANSI_NULLS | ON |
| ANSI_PADDING | ON |
Columns
| Name | Description | Data type | Max length | Nullable | Default | IsGUID | SPARSE | Computed value | ||||
| | AUDIT_LOG_DATA_ID | int | 4 | ||||||||
| 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 | ![]() |
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 |
Columnstore indexes
Identity column
| Name | Seed | Increment | Not for replication | |
![]() |
AUDIT_LOG_DATA_ID | 1 | 1 |
Referenced tables
| Table | Primary key or unique constraint | Foreign key |
| [dbo].[AUDIT_LOG_TRANSACTIONS] | PK__AUDIT_LO__EC2FB09B1A76BC40 | FK_AUDIT_LOG_TRANSACTION_ID |
Objects that depend on [dbo].[AUDIT_LOG_DATA]
Objects that [dbo].[AUDIT_LOG_DATA] depends on
| Object name | Object type | Dep level |
| [dbo].[AUDIT_LOG_TRANSACTIONS] | Table | 1 |
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 |
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 |
See also