rowid is alsways an alias for the primary key whether an "integer primary key" field was specified or not
On Tue, 2004-10-05 at 18:57, Kirk Haines wrote: > Does the SQLite API (for either 2.x or 3.x versions of SQLite) offer > any way to determing which field, if any, in a table was created as an > INTEGER PRIMARY KEY? > > I've looked through the API docs, but either I am overlooking it, or > this capability doesn't exist. > > > Thanks, > > Kirk Haines -- Edward A. Macnaghten http://www.edlsystems.com