Table:
[AdventureWorks2016CTP3].[HumanResources].[Employee_Temporal]
Table properties
| Name | Value |
| Schema | [HumanResources] |
| Owner | [dbo] |
| Table is replicated | |
| Creation date | 23.10.2015 |
| ID | 1870629707 |
| Located on | PRIMARY |
| Data size KB | 56 KB |
| Index size KB | 16 KB |
| Rows | 290 |
| ChangeTrackingEnabled | |
| FileStreamFileGroup | |
| FileStreamPartitionScheme | |
| LockEscalation | TABLE |
| TrackColumnsUpdatedEnabled | |
| Table is filetable | |
| Filetable directory | |
| Filetable collate | |
| Filetable primary key | [PK_Employee_History_BusinessEntityID] |
| 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 | ||
| BusinessEntityID | int | 4 | |||||||
| NationalIDNumber | test | nvarchar | 15 | |||||||
| LoginID | nvarchar | 256 | ||||||||
| OrganizationNode | hierarchyid | 892 | ![]() |
|||||||
| OrganizationLevel | True | smallint | 2 | ![]() |
([OrganizationNode].[GetLevel]()) | |||||
| 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 |
Indexes
| Index | Description | Primary | Unique | Size KB | ||
| [PK_Employee_History_BusinessEntityID] | BusinessEntityID | ![]() |
![]() |
72 | 0 |
Columnstore indexes
Triggers
| Name | Schema | Description | Instead of |
For insert |
For update |
For delete |
Table/view |
| [HumanResources].[tr_u_AUDIT_Employee_Temporal] | [HumanResources] | ![]() |
[HumanResources].[Employee_Temporal] |
Objects that depend on [HumanResources].[Employee_Temporal]
| Object name | Object type | Dep level |
| [Person].[sp_DeletePerson_Temporal] | Procedure | 1 |
| [HumanResources].[sp_UpdateEmployee_Temporal] | Procedure | 1 |
| [HumanResources].[tr_u_AUDIT_Employee_Temporal] | Trigger | 1 |
| [HumanResources].[vEmployeePersonTemporalInfo] | View | 1 |
Objects that [HumanResources].[Employee_Temporal] depends on
| Object name | Object type | Dep level |
| [HumanResources] | Schema | 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 [HumanResources].[Employee_Temporal] ( [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] AS ([OrganizationNode].[GetLevel]()), [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, CONSTRAINT [PK_Employee_History_BusinessEntityID] PRIMARY KEY CLUSTERED ([BusinessEntityID]) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sp_addextendedproperty N'MS_Description', N'ggg', 'SCHEMA', N'HumanResources', 'TABLE', N'Employee_Temporal', 'COLUMN', N'HireDate' GO EXEC sp_addextendedproperty N'aaass', N'test', 'SCHEMA', N'HumanResources', 'TABLE', N'Employee_Temporal', 'COLUMN', N'NationalIDNumber' GO EXEC sp_addextendedproperty N'MS_Description', N'dd', 'SCHEMA', N'HumanResources', 'TABLE', N'Employee_Temporal', 'COLUMN', N'NationalIDNumber' GO |
See also