Name |
Value |
Schema |
[Person] |
Owner |
[dbo] |
Table is replicated |
|
Creation date |
23.10.2015 |
ID |
1534628510 |
Located on |
PRIMARY |
Data size KB |
1624 KB |
Index size KB |
16 KB |
Rows |
19972 |
ChangeTrackingEnabled |
|
FileStreamFileGroup |
|
FileStreamPartitionScheme |
|
LockEscalation |
TABLE |
TrackColumnsUpdatedEnabled |
|
Table is filetable |
|
Filetable directory |
|
Filetable collate |
|
Filetable primary key |
[PK_Person_json_PersonID] |
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 |
[PK_Person_json_PersonID] |
PersonID |
|
 |
 |
1640 |
0 |
Total:
1
Index/indexes
No columnstore indexes exist
Name |
Expression |
AdditionalContactInfo must be formatted as JSON |
(isjson([AdditionalContactInfo])>(0)) |
Demographics must be formatted as JSON |
(isjson([Demographics])>(0)) |
|
Name |
Seed |
Increment |
Not for replication |
 |
PersonID |
1 |
1 |
 |
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 [Person].[Person_json] (
[PersonID] [int] IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
[PersonType] [nchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NameStyle] [dbo].[NameStyle] NOT NULL,
[Title] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirstName] [dbo].[Name] NOT NULL,
[MiddleName] [dbo].[Name] NULL,
[LastName] [dbo].[Name] NOT NULL,
[Suffix] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EmailPromotion] [int] NOT NULL,
[AdditionalContactInfo] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Demographics] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rowguid] [uniqueidentifier] NOT NULL ROWGUIDCOL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_Person_json_PersonID]
PRIMARY KEY
CLUSTERED
([PersonID])
ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [Person].[Person_json]
ADD
CONSTRAINT [AdditionalContactInfo must be formatted as JSON]
CHECK
(isjson([AdditionalContactInfo])>(0))
GO
ALTER TABLE [Person].[Person_json]
CHECK CONSTRAINT [AdditionalContactInfo must be formatted as JSON]
GO
ALTER TABLE [Person].[Person_json]
ADD
CONSTRAINT [Demographics must be formatted as JSON]
CHECK
(isjson([Demographics])>(0))
GO
ALTER TABLE [Person].[Person_json]
CHECK CONSTRAINT [Demographics must be formatted as JSON]
GO
ALTER TABLE [Person].[Person_json]
ADD
CONSTRAINT [DF__Person_js__Email__5E54FF49]
DEFAULT ((0)) FOR [EmailPromotion]
GO
ALTER TABLE [Person].[Person_json]
ADD
CONSTRAINT [DF__Person_js__Modif__6225902D]
DEFAULT (getdate()) FOR [ModifiedDate]
GO
ALTER TABLE [Person].[Person_json]
ADD
CONSTRAINT [DF__Person_js__NameS__5D60DB10]
DEFAULT ((0)) FOR [NameStyle]
GO
ALTER TABLE [Person].[Person_json]
ADD
CONSTRAINT [DF__Person_js__rowgu__61316BF4]
DEFAULT (newid()) FOR [rowguid]
GO
|