Re: [sqlite] Determining an auto increment primary key

On Mar 6, 2004, at 11:01 PM, Fred Williams wrote: But when attempting the same trick for indexes with: "PRAGMA index_info(index-name)" I am getting an empty result set. What is the structure of the index-name? I believe index-name is just whatever name you used to create the index. ---

RE: [sqlite] Determining an auto increment primary key

I have also been looking to retrieve schema data as well. I have managed to get the: "PRAGMA table_info()" to return a result set. But when attempting the same trick for indexes with: "PRAGMA index_info(index-name)" I am getting an empty result set. What is the structure of the index-name? Withi

Re: [sqlite] Determining an auto increment primary key

> On Mar 6, 2004, at 3:25 PM, Richard Heyes wrote: > > > Is there a de-facto method of determining if a column is an INTEGER > > PRIMARY > > KEY column (ie the auto increment type). Best I can come up with is > > checking > > the type and if it has a unique index on it, which isn't definitive >

Re: [sqlite] Determining an auto increment primary key

On Mar 6, 2004, at 3:25 PM, Richard Heyes wrote: Is there a de-facto method of determining if a column is an INTEGER PRIMARY KEY column (ie the auto increment type). Best I can come up with is checking the type and if it has a unique index on it, which isn't definitive since it could just be an

[sqlite] Determining an auto increment primary key

Is there a de-facto method of determining if a column is an INTEGER PRIMARY KEY column (ie the auto increment type). Best I can come up with is checking the type and if it has a unique index on it, which isn't definitive since it could just be an integer column with a unique index. Thanks. -- Ric