Rowid Tables

Rowid Tables

1.0 Definition

A "rowid table" is any table in an SQLite schema that

• is not a virtual table, and
• is not a WITHOUT ROWID table.

Most tables in a typical SQLite database schema are rowid tables.

Rowid tables are distinguished by the fact that they all have a unique, non-NULL, signed 64-bit integer rowid that is used as the access key for the data in the underlying B-tree storage engine.

2.0 Quirks

• The PRIMARY KEY of a rowid table (if there is one) is usually not the true primary key for the table, in the sense that it is not the unique key used by the underlying 登录查看完整内容