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.