Table: [AdventureWorks2016CTP3].[Person].[Person_Temporal_History]

CollapseAll image

Collapse image Table properties


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

Collapse image Creation options


Name  Value 
QUOTED_IDENTIFIER ON
ANSI_NULLS ON
ANSI_PADDING ON

Collapse image Columns


  Name  Description  Data type  Max length  Nullable  Default IsGUID  SPARSE Computed value
  BusinessEntityID     int 4        
  PersonType     nchar 2        
  NameStyle     [dbo].[NameStyle] 1        
  Title     nvarchar 8      
  FirstName     [dbo].[Name] 50        
  MiddleName     [dbo].[Name] 50      
  LastName     [dbo].[Name] 50        
  Suffix     nvarchar 10      
  EmailPromotion     int 4        
  ValidFrom     datetime2 8        
  ValidTo     datetime2 8        
Total: 11 column(s)

Collapse image Indexes


Index  Description  Primary  Unique  Size KB 
[ix_Person_Temporal_History] BusinessEntityID       0 0
Total: 1 Index/indexes

Collapse image Columnstore indexes


No columnstore indexes exist

Collapse image Objects that [Person].[Person_Temporal_History] depends on


Object name Object type Dep level
[Person] Schema 1
[dbo].[Name] Datatype 1
[dbo].[NameStyle] Datatype 1
Total 3 object(s)

Collapse image 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

Collapse image SQL


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

Collapse image See also


List of tables