Create Azure SQL DB In-Memory Table

InMemTable.sql

-- configure recommended DB option
ALTER DATABASE CURRENT SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT=ON;
GO

-- validate tier
IF (DatabasePropertyEx(DB_Name(), 'IsXTPSupported') = 0)
BEGIN
  PRINT 'This database does not support in-mem database.'
  RETURN
END

-- so we can run this over and over
DROP TABLE IF EXISTS dbo.Users
DROP TABLE IF EXISTS dbo.InMemUsers
GO

-- create table of record with sample data
WITH [generator] (Id) AS 
(
  SELECT 1
  UNION ALL
  SELECT [Id] + 1 FROM generator WHERE [Id] < 1000
)
SELECT 
    Id
  , NEWID() as FirstName
  , NEWID() as LastName
INTO dbo.Users
FROM [generator] OPTION (MAXRECURSION 0)

-- create table (non-persist for reading)
CREATE TABLE dbo.InMemUsers
(   
    Id INT PRIMARY KEY NONCLUSTERED
  , FirstName NVARCHAR(50)
  , LastName NVARCHAR(50)
) WITH (MEMORY_OPTIMIZED=ON, DURABILITY=SCHEMA_ONLY);
GO

-- copy from table of record into in-mem table
INSERT INTO dbo.InMemUsers 
(Id, FirstName, LastName)
SELECT Id, FirstName, LastName from dbo.Users

-- query
SELECT COUNT(*) FROM dbo.InMemUsers