BareFeet wrote: > > >>> How can I get just the column headers without all the result rows? >>> >> Turn headers on, then perform a search which gives no results. >> > > Unfortunately, the sqlite3 command line tool does not show the headers > when there are no result rows. > > You can change that behavior with the pragma empty_result_callbacks (see http://www.sqlite.org/pragma.html).
SQLite version 3.6.16 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(a,b); sqlite> pragma empty_result_callbacks=1; sqlite> .header on sqlite> select * from t; a|b HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users