Table: [AdventureWorks2016CTP3].[Sales].[SalesOrderHeader_ondisk]

CollapseAll image

Collapse image Table properties


Name  Value 
 Schema  [Sales]
 Owner  [dbo]
 Table is replicated   
 Creation date  23.10.2015
 ID  1092198941
 Located on  PRIMARY
 Data size KB  4936 KB
 Index size KB  928 KB
 Rows  31465
 ChangeTrackingEnabled   
 FileStreamFileGroup   
 FileStreamPartitionScheme   
 LockEscalation  TABLE
 TrackColumnsUpdatedEnabled   
 Table is filetable   
 Filetable directory   
 Filetable collate   
 Filetable primary key  [PK__SalesOrd__B14003C2B181FB70]
 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__B14003C2B181FB70] SalesOrderID   5864 0
[IX_CustomerID] CustomerID       456 0
[IX_SalesPersonID] SalesPersonID       456 0
Total: 3 Index/indexes

Collapse image Columnstore indexes


No columnstore indexes exist

Collapse image Check constraints


Name  Expression 
ODCK_SalesOrderHeader_DueDate ([DueDate]>=[OrderDate])
ODCK_SalesOrderHeader_Freight ([Freight]>=(0.00))
ODCK_SalesOrderHeader_ShipDate ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
ODCK_SalesOrderHeader_Status ([Status]>=(0) AND [Status]<=(8))
ODCK_SalesOrderHeader_SubTotal ([SubTotal]>=(0.00))
ODCK_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_ondisk] ODFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID PK__SalesOrd__B14003C2B181FB70
Total: 1 table(s)

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


Object name Object type Dep level
[Demo].[usp_DemoReset] Procedure 1
[Sales].[usp_InsertSalesOrder_ondisk] Procedure 1
[Sales].[usp_UpdateSalesOrderShipInfo_ondisk] Procedure 1
[Sales].[SalesOrderDetail_ondisk] Table 1
Total 4 object(s)

Collapse image Objects that [Sales].[SalesOrderHeader_ondisk] 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_ondisk] (
        [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__B14003C2B181FB70]
        PRIMARY KEY
        CLUSTERED
        ([SalesOrderID])
    ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODCK_SalesOrderHeader_DueDate]
    CHECK
    ([DueDate]>=[OrderDate])
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
CHECK CONSTRAINT [ODCK_SalesOrderHeader_DueDate]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODCK_SalesOrderHeader_Freight]
    CHECK
    ([Freight]>=(0.00))
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
CHECK CONSTRAINT [ODCK_SalesOrderHeader_Freight]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODCK_SalesOrderHeader_ShipDate]
    CHECK
    ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL)
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
CHECK CONSTRAINT [ODCK_SalesOrderHeader_ShipDate]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODCK_SalesOrderHeader_Status]
    CHECK
    ([Status]>=(0) AND [Status]<=(8))
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
CHECK CONSTRAINT [ODCK_SalesOrderHeader_Status]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODCK_SalesOrderHeader_SubTotal]
    CHECK
    ([SubTotal]>=(0.00))
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
CHECK CONSTRAINT [ODCK_SalesOrderHeader_SubTotal]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODCK_SalesOrderHeader_TaxAmt]
    CHECK
    ([TaxAmt]>=(0.00))
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
CHECK CONSTRAINT [ODCK_SalesOrderHeader_TaxAmt]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODDF_SalesOrderHeader_Freight]
    DEFAULT ((0.00)) FOR [Freight]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODDF_SalesOrderHeader_OnlineOrderFlag]
    DEFAULT ((1)) FOR [OnlineOrderFlag]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODDF_SalesOrderHeader_RevisionNumber]
    DEFAULT ((0)) FOR [RevisionNumber]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODDF_SalesOrderHeader_SalesPersonID]
    DEFAULT ((-1)) FOR [SalesPersonID]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODDF_SalesOrderHeader_Status]
    DEFAULT ((1)) FOR [Status]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODDF_SalesOrderHeader_SubTotal]
    DEFAULT ((0.00)) FOR [SubTotal]
GO
ALTER TABLE [Sales].[SalesOrderHeader_ondisk]
    ADD
    CONSTRAINT [ODDF_SalesOrderHeader_TaxAmt]
    DEFAULT ((0.00)) FOR [TaxAmt]
GO
CREATE NONCLUSTERED INDEX [IX_CustomerID]
    ON [Sales].[SalesOrderHeader_ondisk] ([CustomerID])
    ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SalesPersonID]
    ON [Sales].[SalesOrderHeader_ondisk] ([SalesPersonID])
    ON [PRIMARY]
GO

Collapse image See also


List of tables