Re: [sqlite] Determining the primary key of a table?

2005-01-24 Thread Dennis Cote
Ned Batchelder 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: That is because there isn't a seperate index on the table using that column. That column is the key

RE: [sqlite] Determining the primary key of a table?

2005-01-23 Thread Ned Batchelder
: 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 pragm

Re: [sqlite] Determining the primary key of a table?

2005-01-23 Thread Will Leshner
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

RE: [sqlite] Determining the primary key of a table?

2005-01-23 Thread Ned Batchelder
Sent: Sunday, January 23, 2005 12:55 PM To: sqlite-users@sqlite.org Subject: [sqlite] Determining the primary key of a table? I need to examine the schema of a SQLite database programmatically. I've managed to find everything I need in the various pragmas for querying the schema, excep

[sqlite] Determining the primary key of a table?

2005-01-23 Thread Ned Batchelder
I need to examine the schema of a SQLite database programmatically. I've managed to find everything I need in the various pragmas for querying the schema, except: the order of the columns in the primary key. pragma table_info tells me which columns are in the primary key, but not their order