| Name |
Value |
| Schema |
[Sales] |
| Owner |
[dbo] |
| Table is replicated |
|
| Creation date |
23.10.2015 |
| ID |
1332199796 |
| Located on |
PRIMARY |
| Data size KB |
8432 KB |
| Index size KB |
2728 KB |
| Rows |
121317 |
| ChangeTrackingEnabled |
|
| FileStreamFileGroup |
|
| FileStreamPartitionScheme |
|
| LockEscalation |
TABLE |
| TrackColumnsUpdatedEnabled |
|
| Table is filetable |
|
| Filetable directory |
|
| Filetable collate |
|
| Filetable primary key |
[ODPK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID] |
| Filetable streamid unique |
|
| Filetable fullpath unique |
|
| Filetable is enabled |
|
| Is memory optimized |
|
| Durability |
SCHEMA_AND_DATA |
| Name |
Value |
| QUOTED_IDENTIFIER |
ON |
| ANSI_NULLS |
ON |
| ANSI_PADDING |
ON |
| Index |
Description |
Primary |
Unique |
Size KB |
| [ODPK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID] |
SalesOrderID |
|
 |
 |
11160 |
0 |
| [IX_ProductID] |
ProductID |
|
|
|
2672 |
0 |
Total:
2
Index/indexes
No columnstore indexes exist
| Name |
Expression |
| ODCK_SalesOrderDetail_OrderQty |
([OrderQty]>(0)) |
| ODCK_SalesOrderDetail_UnitPrice |
([UnitPrice]>=(0.00)) |
| ODCK_SalesOrderDetail_UnitPriceDiscount |
([UnitPriceDiscount]>=(0.00)) |
|
|
Name |
Seed |
Increment |
Not for replication |
 |
SalesOrderDetailID |
1 |
1 |
|
| 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 |
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [Sales].[SalesOrderDetail_ondisk] (
[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 [ODPK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID]
PRIMARY KEY
CLUSTERED
([SalesOrderID], [SalesOrderDetailID])
ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
ADD
CONSTRAINT [ODCK_SalesOrderDetail_OrderQty]
CHECK
([OrderQty]>(0))
GO
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
CHECK CONSTRAINT [ODCK_SalesOrderDetail_OrderQty]
GO
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
ADD
CONSTRAINT [ODCK_SalesOrderDetail_UnitPrice]
CHECK
([UnitPrice]>=(0.00))
GO
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
CHECK CONSTRAINT [ODCK_SalesOrderDetail_UnitPrice]
GO
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
ADD
CONSTRAINT [ODCK_SalesOrderDetail_UnitPriceDiscount]
CHECK
([UnitPriceDiscount]>=(0.00))
GO
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
CHECK CONSTRAINT [ODCK_SalesOrderDetail_UnitPriceDiscount]
GO
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
ADD
CONSTRAINT [ODDF_SalesOrderDetail_UnitPriceDiscount]
DEFAULT ((0.0)) FOR [UnitPriceDiscount]
GO
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
WITH CHECK
ADD CONSTRAINT [ODFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID]
FOREIGN KEY ([SalesOrderID]) REFERENCES [Sales].[SalesOrderHeader_ondisk] ([SalesOrderID])
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
CHECK CONSTRAINT [ODFK_SalesOrderDetail_SalesOrderHeader_SalesOrderID]
GO
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
WITH CHECK
ADD CONSTRAINT [ODFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID]
FOREIGN KEY ([SpecialOfferID], [ProductID]) REFERENCES [Sales].[SpecialOfferProduct_ondisk] ([SpecialOfferID], [ProductID])
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
CHECK CONSTRAINT [ODFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID]
GO
CREATE NONCLUSTERED INDEX [IX_ProductID]
ON [Sales].[SalesOrderDetail_ondisk] ([ProductID])
ON [PRIMARY]
GO
|