Name |
Value |
Schema |
[Sales] |
Owner |
[dbo] |
Table is replicated |
|
Creation date |
23.10.2015 |
ID |
628197288 |
Located on |
PRIMARY |
Data size KB |
8 KB |
Index size KB |
8 KB |
Rows |
16 |
ChangeTrackingEnabled |
|
FileStreamFileGroup |
|
FileStreamPartitionScheme |
|
LockEscalation |
TABLE |
TrackColumnsUpdatedEnabled |
|
Table is filetable |
|
Filetable directory |
|
Filetable collate |
|
Filetable primary key |
[ODPK_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 |
[ODPK_SpecialOffer_SpecialOfferID] |
SpecialOfferID |
|
 |
 |
16 |
0 |
Total:
1
Index/indexes
No columnstore indexes exist
Name |
Expression |
ODCK_SpecialOffer_DiscountPct |
([DiscountPct]>=(0.00)) |
ODCK_SpecialOffer_EndDate |
([EndDate]>=[StartDate]) |
ODCK_SpecialOffer_MaxQty |
([MaxQty]>=(0)) |
ODCK_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_ondisk] (
[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 [ODPK_SpecialOffer_SpecialOfferID]
PRIMARY KEY
CLUSTERED
([SpecialOfferID])
ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
ADD
CONSTRAINT [ODCK_SpecialOffer_DiscountPct]
CHECK
([DiscountPct]>=(0.00))
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
CHECK CONSTRAINT [ODCK_SpecialOffer_DiscountPct]
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
ADD
CONSTRAINT [ODCK_SpecialOffer_EndDate]
CHECK
([EndDate]>=[StartDate])
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
CHECK CONSTRAINT [ODCK_SpecialOffer_EndDate]
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
ADD
CONSTRAINT [ODCK_SpecialOffer_MaxQty]
CHECK
([MaxQty]>=(0))
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
CHECK CONSTRAINT [ODCK_SpecialOffer_MaxQty]
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
ADD
CONSTRAINT [ODCK_SpecialOffer_MinQty]
CHECK
([MinQty]>=(0))
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
CHECK CONSTRAINT [ODCK_SpecialOffer_MinQty]
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
ADD
CONSTRAINT [ODDF_SpecialOffer_DiscountPct]
DEFAULT ((0.00)) FOR [DiscountPct]
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
ADD
CONSTRAINT [ODDF_SpecialOffer_MinQty]
DEFAULT ((0)) FOR [MinQty]
GO
ALTER TABLE [Sales].[SpecialOffer_ondisk]
ADD
CONSTRAINT [ODDF_SpecialOffer_ModifiedDate]
DEFAULT (sysdatetime()) FOR [ModifiedDate]
GO
|