To improve efficiency you could add "where 1=2" to avoid returning any
rows. Should just check validity.
On 5/7/2014 8:19 AM, Stephan Beal wrote:
On Wed, May 7, 2014 at 4:57 PM, Simon Slavin <slav...@bigfraud.org> wrote:
somehow ? Perhaps the ROWID field of a table might have its own
particular indication, and if you don't see any rows marked like that you
could deduce that the table had no ROWID column. I'm sure there are better
ways the
This isn't efficient, but it should work without corner cases: (pseudocode):
function hasRowId(tablename) {
prepare SELECT 1 FROM tablename; // if this fails, tablename likely does
not exist. else...
prepare SELECT rowid FROM tablename; // if this fails, rowid missing
return true only if the second PREPARE succeeds.
}
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users