Re: [sqlite] determing the primary key

2005-04-12 Thread Will Leshner
On 4/12/05, Thomas Briggs <[EMAIL PROTECTED]> wrote: > >Aliases rowid to rowid seems to work for me, i.e. Aha. I forgot about that trick. Thanks!

RE: [sqlite] determing the primary key

2005-04-12 Thread Thomas Briggs
Aliases rowid to rowid seems to work for me, i.e. SELECT rowid as rowid, primary_key_col -Tom > -Original Message- > From: Will Leshner [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 12, 2005 5:36 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] determing

[sqlite] determing the primary key

2005-04-12 Thread Will Leshner
I realize that in sqlite 3, if I construct a query with 'rowid' as one of the columns, and the table I am querying explicitly declares an integer primary key column, my results have the table's name for the column and not 'rowid'. What I'm wondering is if there is a good way to determine which of