Table: [AdventureWorks2016CTP3].[Sales].[SalesOrderHeader_inmem]

CollapseAll image

Collapse image Table properties


Name  Value 
 Schema  [Sales]
 Owner  [dbo]
 Table is replicated   
 Creation date  23.10.2015
 ID  212195806
 Located on   
 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  [PK__SalesOrd__B14003C3270C320B]
 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
Primary key Identity SalesOrderID     int 4        
    RevisionNumber     tinyint 1   ((0))    
    OrderDate     datetime2 8        
    DueDate     datetime2 8        
    ShipDate     datetime2 8      
    Status     tinyint 1   ((1))    
    OnlineOrderFlag     bit 1   ((1))    
    PurchaseOrderNumber     nvarchar 25      
    AccountNumber     nvarchar 15      
    CustomerID     int 4        
    SalesPersonID     int 4   ((-1))    
    TerritoryID     int 4      
    BillToAddressID     int 4        
    ShipToAddressID     int 4        
    ShipMethodID     int 4        
    CreditCardID     int 4      
    CreditCardApprovalCode     varchar 15      
    CurrencyRateID     int 4      
    SubTotal     money 8   ((0.00))    
    TaxAmt     money 8   ((0.00))    
    Freight     money 8   ((0.00))    
    Comment     nvarchar 128      
    ModifiedDate     datetime2 8        
Total: 23 column(s)

Collapse image Indexes


Index  Description  Primary  Unique  Size KB 
[PK__SalesOrd__B14003C3270C320B] SalesOrderID   0 0
[IX_CustomerID] CustomerID       0 0
[IX_SalesPersonID] SalesPersonID       0 0
Total: 3 Index/indexes

Collapse image Columnstore indexes


No columnstore indexes exist

Collapse image Check constraints


Name  Expression 
IMCK_SalesOrderHeader_DueDate ([DueDate]>=[OrderDate])
IMCK_SalesOrderHeader_Freight ([Freight]>=(0.00))
IMCK_SalesOrderHeader_ShipDate ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
IMCK_SalesOrderHeader_Status ([Status]>=(0) AND [Status]<=(8))
IMCK_SalesOrderHeader_SubTotal ([SubTotal]>=(0.00))
IMCK_SalesOrderHeader_TaxAmt ([TaxAmt]>=(0.00))

Collapse image Identity column


  Name  Seed  Increment  Not for replication 
 SalesOrderID   1   1   

Collapse image Referencing tables


Table  Foreign key  Primary key or unique constraint 
[Sales].[SalesOrderDetail_inmem] IMFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID PK__SalesOrd__B14003C3270C320B
Total: 1 table(s)

Collapse image Objects that depend on [Sales].[SalesOrderHeader_inmem]


Object name Object type Dep level
[Demo].[usp_DemoInitSeed] Procedure 1
[Demo].[usp_DemoReset] Procedure 1
[Sales].[SalesOrderDetail_inmem] Table 1
[Sales].[vSalesOrderHeader_extended_inmem] Function 1
Total 4 object(s)

Collapse image Objects that [Sales].[SalesOrderHeader_inmem] depends on


Object name Object type Dep level
[Sales] Schema 1
Total 1 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 [Sales].[SalesOrderHeader_inmem] (
        [SalesOrderID]               [int] IDENTITY(1, 1) NOT NULL,
        [RevisionNumber]             [tinyint] NOT NULL,
        [OrderDate]                  [datetime2](7) NOT NULL,
        [DueDate]                    [datetime2](7) NOT NULL,
        [ShipDate]                   [datetime2](7) NULL,
        [Status]                     [tinyint] NOT NULL,
        [OnlineOrderFlag]            [bit] NOT NULL,
        [PurchaseOrderNumber]        [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [AccountNumber]              [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [CustomerID]                 [int] NOT NULL,
        [SalesPersonID]              [int] NOT NULL,
        [TerritoryID]                [int] NULL,
        [BillToAddressID]            [int] NOT NULL,
        [ShipToAddressID]            [int] NOT NULL,
        [ShipMethodID]               [int] NOT NULL,
        [CreditCardID]               [int] NULL,
        [CreditCardApprovalCode]     [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [CurrencyRateID]             [int] NULL,
        [SubTotal]                   [money] NOT NULL,
        [TaxAmt]                     [money] NOT NULL,
        [Freight]                    [money] NOT NULL,
        [Comment]                    [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [ModifiedDate]               [datetime2](7) NOT NULL,
        CONSTRAINT [PK__SalesOrd__B14003C3270C320B]
        PRIMARY KEY
        NONCLUSTERED HASH
        ([SalesOrderID])
        WITH (BUCKET_COUNT=16777216),
INDEX [IX_CustomerID] NONCLUSTERED HASH  ([CustomerID])
    WITH ( BUCKET_COUNT=1048576),
INDEX [IX_SalesPersonID] NONCLUSTERED HASH  ([SalesPersonID])
    WITH ( BUCKET_COUNT=1048576)
)
WITH (MEMORY_OPTIMIZED=ON, DURABILITY=SCHEMA_AND_DATA)
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMCK_SalesOrderHeader_DueDate]
    CHECK
    ([DueDate]>=[OrderDate])
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
CHECK CONSTRAINT [IMCK_SalesOrderHeader_DueDate]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMCK_SalesOrderHeader_Freight]
    CHECK
    ([Freight]>=(0.00))
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
CHECK CONSTRAINT [IMCK_SalesOrderHeader_Freight]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMCK_SalesOrderHeader_ShipDate]
    CHECK
    ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
CHECK CONSTRAINT [IMCK_SalesOrderHeader_ShipDate]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMCK_SalesOrderHeader_Status]
    CHECK
    ([Status]>=(0) AND [Status]<=(8))
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
CHECK CONSTRAINT [IMCK_SalesOrderHeader_Status]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMCK_SalesOrderHeader_SubTotal]
    CHECK
    ([SubTotal]>=(0.00))
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
CHECK CONSTRAINT [IMCK_SalesOrderHeader_SubTotal]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMCK_SalesOrderHeader_TaxAmt]
    CHECK
    ([TaxAmt]>=(0.00))
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
CHECK CONSTRAINT [IMCK_SalesOrderHeader_TaxAmt]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMDF_SalesOrderHeader_Freight]
    DEFAULT ((0.00)) FOR [Freight]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMDF_SalesOrderHeader_OnlineOrderFlag]
    DEFAULT ((1)) FOR [OnlineOrderFlag]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMDF_SalesOrderHeader_RevisionNumber]
    DEFAULT ((0)) FOR [RevisionNumber]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMDF_SalesOrderHeader_SalesPersonID]
    DEFAULT ((-1)) FOR [SalesPersonID]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMDF_SalesOrderHeader_Status]
    DEFAULT ((1)) FOR [Status]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMDF_SalesOrderHeader_SubTotal]
    DEFAULT ((0.00)) FOR [SubTotal]
GO
ALTER TABLE [Sales].[SalesOrderHeader_inmem]
    ADD
    CONSTRAINT [IMDF_SalesOrderHeader_TaxAmt]
    DEFAULT ((0.00)) FOR [TaxAmt]
GO

Collapse image See also


List of tables