| 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
|