Good point....so probably time equivalent either way. Though table_info will allow the feature creep of "does a column exist" pretty easily. Not that anybody ever adds requirements....
Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: [email protected] [[email protected]] on behalf of Igor Tandetnik [[email protected]] Sent: Friday, July 20, 2012 7:59 AM To: [email protected] Subject: EXT :Re: [sqlite] database AND table already exist? Black, Michael (IS) <[email protected]> wrote: > table_info() will be faster than doing "select *" I would think in most all > cases. To check the existence of a table, you don't need to actually run the select statement - just prepare it and check for errors. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
