SQLite Forum

Primary Key v Unique Index
Login
Yes, the incantation rules have been relaxed. You can now say CREATE TABLE ... (id INTEGER, <insert lots of fields and constraints>, PRIMARY KEY (id)); and get the same effect. I would still recommend using the original incantation.

OT: Watching hollywood films gives the impression that Latin was dropped from common use because it was too easy to inadvertently summon a demon during normal conversation.