| Name |
Value |
| Schema |
[Person] |
| Owner |
[dbo] |
| Table is replicated |
|
| Creation date |
23.10.2015 |
| ID |
1854629650 |
| 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 |
|
| 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 |
| [ix_Person_Temporal_History] |
BusinessEntityID |
|
|
|
0 |
0 |
Total:
1
Index/indexes
No columnstore indexes exist
| 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 [Person].[Person_Temporal_History] (
[BusinessEntityID] [int] NOT NULL,
[PersonType] [nchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NameStyle] [dbo].[NameStyle] NOT NULL,
[Title] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirstName] [dbo].[Name] NOT NULL,
[MiddleName] [dbo].[Name] NULL,
[LastName] [dbo].[Name] NOT NULL,
[Suffix] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EmailPromotion] [int] NOT NULL,
[ValidFrom] [datetime2](7) NOT NULL,
[ValidTo] [datetime2](7) NOT NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ix_Person_Temporal_History]
ON [Person].[Person_Temporal_History] ([BusinessEntityID], [ValidFrom], [ValidTo])
WITH ( DATA_COMPRESSION = PAGE)
ON [PRIMARY]
GO
|