Re: [sqlite] PRIMARY KEY Issue

On Jun 12, 2005, at 5:22 AM, Ken & Deb Allen wrote: 1. CREATE TABLE Table1 (PKey INTEGER UNIQUE NOT NULL, Col2 VARCHAR (32) NOT NULL, Col3 VARCHAR(64) NULL); Creates a separate index. 2. CREATE TABLE Table2 (PKey INTEGER NOT NULL PRIMARY KEY, Col2 VARCHAR(32) NOT NULL, Col3 VARCHAR(64) N

[sqlite] PRIMARY KEY Issue

I have seen frequent mention that the "most efficient" key for a SQLITE3 table is to declare a column as "INTEGER UNIQUE". I know from past experience that the primary key for any database table should consist of the first and contiguous column(s) in the table. Does SQLITE3 treat the follow