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?
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
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
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
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
5 matches
Mail list logo