| Name |
Value |
| Schema |
[Sales] |
| Owner |
[dbo] |
| Table is replicated |
|
| Creation date |
23.10.2015 |
| ID |
1895677801 |
| 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_SpecialOffer_SpecialOfferID] |
| 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 |
| [IMPK_SpecialOffer_SpecialOfferID] |
SpecialOfferID |
|
 |
 |
0 |
0 |
Total:
1
Index/indexes
No columnstore indexes exist
| Name |
Expression |
| IMCK_SpecialOffer_DiscountPct |
([DiscountPct]>=(0.00)) |
| IMCK_SpecialOffer_EndDate |
([EndDate]>=[StartDate]) |
| IMCK_SpecialOffer_MaxQty |
([MaxQty]>=(0)) |
| IMCK_SpecialOffer_MinQty |
([MinQty]>=(0)) |
|
|
Name |
Seed |
Increment |
Not for replication |
 |
SpecialOfferID |
1 |
1 |
|
| Object name |
Object type |
Dep level |
| [Sales] |
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 [Sales].[SpecialOffer_inmem] (
[SpecialOfferID] [int] IDENTITY(1, 1) NOT NULL,
[Description] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DiscountPct] [smallmoney] NOT NULL,
[Type] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Category] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StartDate] [datetime2](7) NOT NULL,
[EndDate] [datetime2](7) NOT NULL,
[MinQty] [int] NOT NULL,
[MaxQty] [int] NULL,
[ModifiedDate] [datetime2](7) NOT NULL,
CONSTRAINT [IMPK_SpecialOffer_SpecialOfferID]
PRIMARY KEY
NONCLUSTERED HASH
([SpecialOfferID])
WITH (BUCKET_COUNT=1048576)
)
WITH (MEMORY_OPTIMIZED=ON, DURABILITY=SCHEMA_AND_DATA)
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
ADD
CONSTRAINT [IMCK_SpecialOffer_DiscountPct]
CHECK
([DiscountPct]>=(0.00))
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
CHECK CONSTRAINT [IMCK_SpecialOffer_DiscountPct]
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
ADD
CONSTRAINT [IMCK_SpecialOffer_EndDate]
CHECK
([EndDate]>=[StartDate])
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
CHECK CONSTRAINT [IMCK_SpecialOffer_EndDate]
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
ADD
CONSTRAINT [IMCK_SpecialOffer_MaxQty]
CHECK
([MaxQty]>=(0))
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
CHECK CONSTRAINT [IMCK_SpecialOffer_MaxQty]
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
ADD
CONSTRAINT [IMCK_SpecialOffer_MinQty]
CHECK
([MinQty]>=(0))
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
CHECK CONSTRAINT [IMCK_SpecialOffer_MinQty]
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
ADD
CONSTRAINT [IMDF_SpecialOffer_DiscountPct]
DEFAULT ((0.00)) FOR [DiscountPct]
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
ADD
CONSTRAINT [IMDF_SpecialOffer_MinQty]
DEFAULT ((0)) FOR [MinQty]
GO
ALTER TABLE [Sales].[SpecialOffer_inmem]
ADD
CONSTRAINT [IMDF_SpecialOffer_ModifiedDate]
DEFAULT (sysdatetime()) FOR [ModifiedDate]
GO
|