On 20 July 2012 12:51, Simon Slavin wrote: > PRAGMA table_info(myTable)
For just determining whether or not the table exists, we use: SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='some_table'; which seems easier than getting "one row for each column in the named table". Obviously this doesn't tell you anything about the schema of the table, just a '1' or a '0'. Regards, Paul. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
