| Name |
Value |
| Schema |
[dbo] |
| Owner |
[dbo] |
| Table is replicated |
|
| Creation date |
21.09.2016 |
| ID |
88387384 |
| Located on |
PRIMARY |
| Data size KB |
312 KB |
| Index size KB |
32 KB |
| Rows |
714 |
| ChangeTrackingEnabled |
|
| FileStreamFileGroup |
|
| FileStreamPartitionScheme |
|
| LockEscalation |
TABLE |
| TrackColumnsUpdatedEnabled |
|
| Table is filetable |
|
| Filetable directory |
|
| Filetable collate |
|
| Filetable primary key |
[PK__AUDIT_LO__5E54864804DBC213] |
| Filetable streamid unique |
|
| Filetable fullpath unique |
|
| Filetable is enabled |
|
| Is memory optimized |
|
| Durability |
SCHEMA_AND_DATA |
| Name |
Value |
| QUOTED_IDENTIFIER |
ON |
| ANSI_NULLS |
ON |
| ANSI_PADDING |
ON |
| Index |
Description |
Primary |
Unique |
Size KB |
| [PK__AUDIT_LO__5E54864804DBC213] |
LogId |
|
 |
 |
344 |
0 |
| [IDX1_AUDIT_LOG_DDL] |
LogId |
|
|
|
16 |
0 |
Total:
2
Index/indexes
No columnstore indexes exist
|
|
Name |
Seed |
Increment |
Not for replication |
 |
LogId |
1 |
1 |
|
| 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 |
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AUDIT_LOG_DDL] (
[LogId] [int] IDENTITY(1, 1) NOT NULL,
[DATABASE] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SCHEMA] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OBJECT_TYPE] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OBJECT_NAME] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ACTION] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OLD_VALUE] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NEW_VALUE] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MODIFIED_BY] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MODIFIED_DATE] [datetime] NULL,
[APP_NAME] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[HOST_NAME] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DESCRIPTION] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [PK__AUDIT_LO__5E54864804DBC213]
PRIMARY KEY
CLUSTERED
([LogId])
ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IDX1_AUDIT_LOG_DDL]
ON [dbo].[AUDIT_LOG_DDL] ([LogId])
ON [PRIMARY]
GO
|