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
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:
sqlite> create table foo(a int, b integer primary key, c int);
sqlite> pramga table_info(foo);
cid
4 matches
Mail list logo