The pk column in the table_info pragma is populated, but as I said, the index_list pragma doesn't mention an index.
--Ned. http://nedbatchelder.com -----Original Message----- From: Will Leshner [mailto:[EMAIL PROTECTED] Sent: Sunday, January 23, 2005 3:34 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Determining the primary key of a table? On Sun, 23 Jan 2005 13:18:27 -0500, Ned Batchelder <[EMAIL PROTECTED]> wrote: > One more twist I just discovered: > > If the primary key is a single column that auto-increments, there is no > information in the pragma index_list about the primary key at all: Are you sure? I'm pretty sure I use the 'pk' value from the table_info results in my own SQLite manager application, and it appears to be able to detect the primary key column from the table created by your schema.