Name |
Value |
Schema |
[Sales] |
Owner |
[dbo] |
Table is replicated |
|
Creation date |
23.10.2015 |
ID |
132195521 |
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_SpecialOfferProduct_SpecialOfferID_ProductID] |
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 |
OFF |
Index |
Description |
Primary |
Unique |
Size KB |
[IMPK_SpecialOfferProduct_SpecialOfferID_ProductID] |
SpecialOfferID |
|
 |
 |
0 |
0 |
[ix_ProductID] |
ProductID |
|
|
|
0 |
0 |
Total:
2
Index/indexes
No columnstore indexes exist
Table |
Foreign key |
Primary key or unique constraint |
[Sales].[SalesOrderDetail_inmem] |
IMFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID |
IMPK_SpecialOfferProduct_SpecialOfferID_ProductID |
Total:
1
table(s)
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].[SpecialOfferProduct_inmem] (
[SpecialOfferID] [int] NOT NULL,
[ProductID] [int] NOT NULL,
[ModifiedDate] [datetime2](7) NOT NULL,
CONSTRAINT [IMPK_SpecialOfferProduct_SpecialOfferID_ProductID]
PRIMARY KEY
NONCLUSTERED
([SpecialOfferID], [ProductID])
)
WITH (MEMORY_OPTIMIZED=ON, DURABILITY=SCHEMA_AND_DATA)
GO
ALTER TABLE [Sales].[SpecialOfferProduct_inmem]
ADD
CONSTRAINT [IMDF_SpecialOfferProduct_ModifiedDate]
DEFAULT (sysdatetime()) FOR [ModifiedDate]
GO
ALTER TABLE [Sales].[SpecialOfferProduct_inmem]
WITH CHECK
ADD CONSTRAINT [IMFK_SpecialOfferProduct_Product_ProductID]
FOREIGN KEY ([ProductID]) REFERENCES [Production].[Product_inmem] ([ProductID])
ALTER TABLE [Sales].[SpecialOfferProduct_inmem]
CHECK CONSTRAINT [IMFK_SpecialOfferProduct_Product_ProductID]
GO
ALTER TABLE [Sales].[SpecialOfferProduct_inmem]
WITH CHECK
ADD CONSTRAINT [IMFK_SpecialOfferProduct_SpecialOffer_SpecialOfferID]
FOREIGN KEY ([SpecialOfferID]) REFERENCES [Sales].[SpecialOffer_inmem] ([SpecialOfferID])
ALTER TABLE [Sales].[SpecialOfferProduct_inmem]
CHECK CONSTRAINT [IMFK_SpecialOfferProduct_SpecialOffer_SpecialOfferID]
GO
CREATE NONCLUSTERED INDEX [ix_ProductID]
ON [Sales].[SpecialOfferProduct_inmem] ([ProductID])
WITH ( STATISTICS_NORECOMPUTE = ON, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)
GO
|