On Fri, 15 Nov 2013 16:16:34 -0500 Richard Hipp <d...@sqlite.org> wrote:
> On Fri, Nov 15, 2013 at 4:11 PM, RSmith <rsm...@rsweb.co.za> wrote: > > > I would still like to see some kind of function, even a totally new > > one that does not affect any backward compatibility, such as: > > > > *BOOL sqlite3_table_has_rowid(*tbl); > > How about this: > > SELECT 1 FROM sqlite_master WHERE sql LIKE '%without%rowid%'; Actually, this discussion highlights the fact that row_id always was an attribute of a table, however hidden and magical. Better than a new function would be a new column in SQLITE_MASTER. (LIKE is often a clue that an attribute is encoded in the text!) --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users