>> 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]
