SQLite does things quite differently than most mainstream SQL database engines ... the WITHOUT ROWID clause may be added to the table creation statement: create table Hens ( Name text primary key ) ...