Table:
[AdventureWorks2016CTP3].[dbo].[AUDIT_LOG_TRANSACTIONS]
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 |
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_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])) |
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 |
Columnstore indexes
Identity column
| Name | Seed | Increment | Not for replication | |
![]() |
AUDIT_LOG_TRANSACTION_ID | 1 | 1 |
Referencing tables
| Table | Foreign key | Primary key or unique constraint |
| [dbo].[AUDIT_LOG_DATA] | FK_AUDIT_LOG_TRANSACTION_ID | PK__AUDIT_LO__EC2FB09B1A76BC40 |
Objects that depend on [dbo].[AUDIT_LOG_TRANSACTIONS]
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_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 |
See also