connect-session-knex icon indicating copy to clipboard operation
connect-session-knex copied to clipboard

MSSQL Schema Equivalents - Clustered/Non-Clustered?

Open RayDeanTech opened this issue 3 years ago • 0 comments

Hello, I'm not completely familiar with PostgreSQL/SQLite nomenclature (i.e.: btree). I don't have an option to create a Clustered index for the Expired column.... can it be Non-Clustered?

Best I can glean from Microsoft's documentation is that both Clustered and Non-Clustered are considered "b-tree structures".

I've got the columns setup. I used datetimeoffset(7) for Expired, if you think that's cool:

	[sid] [varchar](255) NOT NULL,
	[sess] [nvarchar](max) NOT NULL,
	[expired] [datetimeoffset](7) NOT NULL,

image

RayDeanTech avatar Jul 26 '21 20:07 RayDeanTech