Name |
Value |
Schema |
[Demo] |
Owner |
[dbo] |
Table is replicated |
|
Creation date |
23.10.2015 |
ID |
1588200708 |
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__499359DA31897820] |
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 |
| | DueDate |
|
|
datetime2 |
8 |
|
|
|
|
|
| | CustomerID |
|
|
int |
4 |
|
|
|
|
|
| | SalesPersonID |
|
|
int |
4 |
|
|
|
|
|
| | BillToAddressID |
|
|
int |
4 |
|
|
|
|
|
| | ShipToAddressID |
|
|
int |
4 |
|
|
|
|
|
| | ShipMethodID |
|
|
int |
4 |
|
|
|
|
|
| | LocalID |
|
|
int |
4 |
|
|
|
|
|
Total:
7
column(s)
Index |
Description |
Primary |
Unique |
Size KB |
[PK__DemoSale__499359DA31897820] |
DueDate |
|
 |
 |
0 |
0 |
Total:
1
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].[DemoSalesOrderHeaderSeed] (
[DueDate] [datetime2](7) NOT NULL,
[CustomerID] [int] NOT NULL,
[SalesPersonID] [int] NOT NULL,
[BillToAddressID] [int] NOT NULL,
[ShipToAddressID] [int] NOT NULL,
[ShipMethodID] [int] NOT NULL,
[LocalID] [int] IDENTITY(1, 1) NOT NULL,
CONSTRAINT [PK__DemoSale__499359DA31897820]
PRIMARY KEY
NONCLUSTERED
([LocalID])
)
WITH (MEMORY_OPTIMIZED=ON, DURABILITY=SCHEMA_AND_DATA)
GO
|