USE in_memory_OLTP
GO
CREATE TABLE [dbo]. [PeopleWithSchema]
(
[PeopleID] [int] NOT NULL PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT= 2000000),
[Fname] [nvarchar] (50) NULL,
[Lname] [nvarchar] (50) NULL,
[Email] [nvarchar] (50) NULL,
[Social Security Number] [nvarchar] (50) NULL,
[Phone] [nvarchar] (50) NULL
)
with (MEMORY_OPTIMIZED= ON, DURABILITY=SCHEMA_ONLY)
go
USE in_memory_OLTP
GO
CREATE TABLE [dbo].[People]
(
[PeopleID] [int] NOT NULL,
[Fname] [nvarchar] (50) NULL,
[Lname] [nvarchar] (50) NULL,
[Email] [nvarchar] (50) NULL,
[Social Security Number] [nvarchar] (50) NULL,
[Phone] [nvarchar] (50) NULL,
CONSTRAINT [PK_People] PRIMARY KEY CLUSTERED
(
[PeopleID] ASC
))
go
USE in_memory_OLTP
GO
CREATE TABLE [dbo].[PeopleWithSchemaData]
(
[PeopleID] [int] NOT NULL PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT= 2000000),
[Fname] [nvarchar] (50) NULL,
[Lname] [nvarchar] (50) NULL,
[Email] [nvarchar] (50) NULL,
[Social Security Number] [nvarchar] (50) NULL,
[Phone] [nvarchar] (50) NULL
)
WITH (MEMORY_OPTIMIZED =ON, DURABILITY =SCHEMA_AND_DATA)
go
