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: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Igor Tandetnik [itandet...@mvps.org] Sent: Friday, July 20, 2012 7:59 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] database AND table already exist? Black, Michael (IS) <michael.bla...@ngc.com> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users