Table:
[AdventureWorks2016CTP3].[Sales].[SalesOrderDetail_inmem]
Table properties
| Name | Value |
| Schema | [Sales] |
| Owner | [dbo] |
| Table is replicated | |
| Creation date | 23.10.2015 |
| ID | 468196718 |
| 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 | [imPK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID] |
| 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 | ||||
| | SalesOrderID | int | 4 | ||||||||
| | SalesOrderDetailID | bigint | 8 | ||||||||
| CarrierTrackingNumber | nvarchar | 25 | ![]() |
|||||||||
| OrderQty | smallint | 2 | ||||||||||
| ProductID | int | 4 | |||||||||
| SpecialOfferID | int | 4 | |||||||||
| UnitPrice | money | 8 | ||||||||||
| UnitPriceDiscount | money | 8 | ((0.0)) | |||||||||
| ModifiedDate | datetime2 | 8 |
Indexes
| Index | Description | Primary | Unique | Size KB | ||
| [imPK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID] | SalesOrderID | ![]() |
![]() |
0 | 0 | |
| [IX_ProductID] | ProductID | 0 | 0 | |||
| [IX_SalesOrderID] | SalesOrderID | 0 | 0 |
Columnstore indexes
Check constraints
| Name | Expression |
| IMCK_SalesOrderDetail_OrderQty | ([OrderQty]>(0)) |
| IMCK_SalesOrderDetail_UnitPrice | ([UnitPrice]>=(0.00)) |
| IMCK_SalesOrderDetail_UnitPriceDiscount | ([UnitPriceDiscount]>=(0.00)) |
Identity column
| Name | Seed | Increment | Not for replication | |
![]() |
SalesOrderDetailID | 1 | 1 |
Referenced tables
| Table | Primary key or unique constraint | Foreign key |
| [Sales].[SalesOrderHeader_inmem] | PK__SalesOrd__B14003C3270C320B | IMFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID |
| [Sales].[SpecialOfferProduct_inmem] | IMPK_SpecialOfferProduct_SpecialOfferID_ProductID | IMFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID |
Objects that depend on [Sales].[SalesOrderDetail_inmem]
| Object name | Object type | Dep level |
| [Demo].[usp_DemoReset] | Procedure | 1 |
| [Sales].[vSalesOrderDetail_extended_inmem] | Function | 1 |
Objects that [Sales].[SalesOrderDetail_inmem] depends on
| Object name | Object type | Dep level |
| [Sales] | Schema | 1 |
| [Sales].[SalesOrderHeader_inmem] | Table | 1 |
| [Sales].[SpecialOfferProduct_inmem] | Table | 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 [Sales].[SalesOrderDetail_inmem] ( [SalesOrderID] [int] NOT NULL, [SalesOrderDetailID] [bigint] IDENTITY(1, 1) NOT NULL, [CarrierTrackingNumber] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OrderQty] [smallint] NOT NULL, [ProductID] [int] NOT NULL, [SpecialOfferID] [int] NOT NULL, [UnitPrice] [money] NOT NULL, [UnitPriceDiscount] [money] NOT NULL, [ModifiedDate] [datetime2](7) NOT NULL, CONSTRAINT [imPK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID] PRIMARY KEY NONCLUSTERED HASH ([SalesOrderID], [SalesOrderDetailID]) WITH (BUCKET_COUNT=67108864), INDEX [IX_ProductID] NONCLUSTERED HASH ([ProductID]) WITH ( BUCKET_COUNT=1048576), INDEX [IX_SalesOrderID] NONCLUSTERED HASH ([SalesOrderID]) WITH ( BUCKET_COUNT=16777216) ) WITH (MEMORY_OPTIMIZED=ON, DURABILITY=SCHEMA_AND_DATA) GO ALTER TABLE [Sales].[SalesOrderDetail_inmem] ADD CONSTRAINT [IMCK_SalesOrderDetail_OrderQty] CHECK ([OrderQty]>(0)) GO ALTER TABLE [Sales].[SalesOrderDetail_inmem] CHECK CONSTRAINT [IMCK_SalesOrderDetail_OrderQty] GO ALTER TABLE [Sales].[SalesOrderDetail_inmem] ADD CONSTRAINT [IMCK_SalesOrderDetail_UnitPrice] CHECK ([UnitPrice]>=(0.00)) GO ALTER TABLE [Sales].[SalesOrderDetail_inmem] CHECK CONSTRAINT [IMCK_SalesOrderDetail_UnitPrice] GO ALTER TABLE [Sales].[SalesOrderDetail_inmem] ADD CONSTRAINT [IMCK_SalesOrderDetail_UnitPriceDiscount] CHECK ([UnitPriceDiscount]>=(0.00)) GO ALTER TABLE [Sales].[SalesOrderDetail_inmem] CHECK CONSTRAINT [IMCK_SalesOrderDetail_UnitPriceDiscount] GO ALTER TABLE [Sales].[SalesOrderDetail_inmem] ADD CONSTRAINT [IMDF_SalesOrderDetail_UnitPriceDiscount] DEFAULT ((0.0)) FOR [UnitPriceDiscount] GO ALTER TABLE [Sales].[SalesOrderDetail_inmem] WITH CHECK ADD CONSTRAINT [IMFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID] FOREIGN KEY ([SalesOrderID]) REFERENCES [Sales].[SalesOrderHeader_inmem] ([SalesOrderID]) ALTER TABLE [Sales].[SalesOrderDetail_inmem] CHECK CONSTRAINT [IMFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID] GO ALTER TABLE [Sales].[SalesOrderDetail_inmem] WITH CHECK ADD CONSTRAINT [IMFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID] FOREIGN KEY ([SpecialOfferID], [ProductID]) REFERENCES [Sales].[SpecialOfferProduct_inmem] ([SpecialOfferID], [ProductID]) ALTER TABLE [Sales].[SalesOrderDetail_inmem] CHECK CONSTRAINT [IMFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID] GO |
See also