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); > > where maybe if the 'tbl' parameter is empty it checks all tables and lets > us know whether any tables in the Schema does not contain a rowid (FALSE) > etc. >
How about this: SELECT 1 FROM sqlite_master WHERE sql LIKE '%without%rowid%'; The above might give you a false positive, for a sufficient malicious schema, but that seems unlikely in practice. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users