Thanks for the assistance. BUT, when I attempt to execute:
select * from sqlite_master where type='index' and tbl_name='Foo';
I get no error message returned, but I also get no data. Executing:
select * from sqlite_master where type='index'
I get the expected result.
Also, executing
Pragma index_info('foo_key');
Also returns no error, as well as no data. I am using SQLite 2.8.8
downloaded for the SQLite Web Site. But, it appears something is broke in my
implementation.
At this point I R' Cornfuzed!
Guess I'll spend some time messing with data tables, testing multi
restricted selects, and see what's up.
Fred
-----Original Message-----
From: Kurt Welgehausen [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 07, 2004 12:25 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Determining an auto increment primary key
>> PRAGMA index_info(index-name)...I am getting an empty result set
You can get index names from sqlite_master:
sqlite> select * from sqlite_master where type='index' and
tbl_name='Persons';
type name tbl_name rootpage sql
---------- ---------------------- ---------- ---------- ----------
index (Persons autoindex 1) Persons 38 <null>
index Persons_Zip Persons 72 create ind...
sqlite> pragma index_info('(Persons autoindex 1)');
seqno cid name
---------- ---------- ----------
0 6 SSNum
sqlite> pragma index_info('Persons_Zip');
seqno cid name
---------- ---------- ----------
0 13 Zip
Of course, an index primary key doesn't show up here, since there's
no index created for it. The best way to get that info is probably
pragma table_info, as suggested in an earlier reponse.
Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
