In that case, the WITHOUT ROWID clause may be added to the table creation statement: create table Hens ( Name text primary key ) without rowid SQLite does, however, require a primary key. So if I ask ...

The third form of the CREATE TABLE statement stores the results of any query-expression in a table and does not display the output. It is a convenient way to create temporary tables that are subsets ...