Table:
[AdventureWorks2016CTP3].[HumanResources].[Employee_Temporal_History]
Name | Value |
Schema | [HumanResources] |
Owner | [dbo] |
Table is replicated | |
Creation date | 23.10.2015 |
ID | 1902629821 |
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 |
Name | Description | Data type | Max length | Nullable | Default | IsGUID | SPARSE | Computed value | ||
BusinessEntityID | int | 4 | ||||||||
NationalIDNumber | nvarchar | 15 | ||||||||
LoginID | nvarchar | 256 | ||||||||
OrganizationNode | hierarchyid | 892 | ![]() |
|||||||
OrganizationLevel | smallint | 2 | ![]() |
|||||||
JobTitle | nvarchar | 50 | ||||||||
BirthDate | date | 3 | ||||||||
MaritalStatus | nchar | 1 | ||||||||
Gender | nchar | 1 | ||||||||
HireDate | date | 3 | ||||||||
VacationHours | smallint | 2 | ||||||||
SickLeaveHours | smallint | 2 | ||||||||
ValidFrom | datetime2 | 8 | ||||||||
ValidTo | datetime2 | 8 |
Index | Description | Primary | Unique | Size KB | ||
[ix_Employee_Temporal_History] | BusinessEntityID | 0 | 0 |
Object name | Object type | Dep level |
[HumanResources] | Schema | 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 [HumanResources].[Employee_Temporal_History] ( [BusinessEntityID] [int] NOT NULL, [NationalIDNumber] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [LoginID] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [OrganizationNode] [hierarchyid] NULL, [OrganizationLevel] [smallint] NULL, [JobTitle] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [BirthDate] [date] NOT NULL, [MaritalStatus] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Gender] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [HireDate] [date] NOT NULL, [VacationHours] [smallint] NOT NULL, [SickLeaveHours] [smallint] NOT NULL, [ValidFrom] [datetime2](7) NOT NULL, [ValidTo] [datetime2](7) NOT NULL ) ON [PRIMARY] GO CREATE CLUSTERED INDEX [ix_Employee_Temporal_History] ON [HumanResources].[Employee_Temporal_History] ([BusinessEntityID], [ValidFrom], [ValidTo]) WITH ( DATA_COMPRESSION = PAGE) ON [PRIMARY] GO EXEC sp_addextendedproperty N'MS_Description', N'test66', 'SCHEMA', N'HumanResources', 'TABLE', N'Employee_Temporal_History', 'COLUMN', N'NationalIDNumber' GO |