On Fri, Nov 15, 2013 at 4:11 PM, RSmith <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
