| Name |
Value |
| Schema |
[Demo] |
| Owner |
[dbo] |
| Table is replicated |
|
| Creation date |
23.10.2015 |
| ID |
1556200594 |
| 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__DemoSale__499359DA37DC4424] |
| 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 |
|
|
|
Name |
Description |
Data type |
Max length |
Nullable |
Default |
IsGUID |
SPARSE |
Computed value |
| | | OrderQty |
|
|
smallint |
2 |
|
|
|
|
|
| | | ProductID |
|
|
int |
4 |
|
|
|
|
|
| | | SpecialOfferID |
|
|
int |
4 |
|
|
|
|
|
| | | OrderID |
|
|
int |
4 |
|
|
|
|
|
| | LocalID |
|
|
int |
4 |
|
|
|
|
|
Total:
5
column(s)
| Index |
Description |
Primary |
Unique |
Size KB |
| [PK__DemoSale__499359DA37DC4424] |
OrderQty |
|
 |
 |
0 |
0 |
| [IX_OrderID] |
OrderID |
|
|
|
0 |
0 |
Total:
2
Index/indexes
No columnstore indexes exist
|
|
Name |
Seed |
Increment |
Not for replication |
 |
LocalID |
1 |
1 |
|
| Object name |
Object type |
Dep level |
| [Demo] |
Schema |
1 |
Total
1
object(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 [Demo].[DemoSalesOrderDetailSeed] (
[OrderQty] [smallint] NOT NULL,
[ProductID] [int] NOT NULL,
[SpecialOfferID] [int] NOT NULL,
[OrderID] [int] NOT NULL,
[LocalID] [int] IDENTITY(1, 1) NOT NULL,
CONSTRAINT [PK__DemoSale__499359DA37DC4424]
PRIMARY KEY
NONCLUSTERED
([LocalID]),
INDEX [IX_OrderID] NONCLUSTERED HASH ([OrderID])
WITH ( BUCKET_COUNT=1048576)
)
WITH (MEMORY_OPTIMIZED=ON, DURABILITY=SCHEMA_AND_DATA)
GO
|