SQLite Forum

Clustered vs Non Clustered Indexes in SQLite
Login
A Clustered-Index in SQL Server is the equivalent of the PRIMARY KEY on a
WITHOUT ROWID table in SQLite.  Or, if the PRIMARY KEY is just an integer,
then it is the clustered index for the ordinary rowid table.