On 29 Jun 2009, at 1:05pm, 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. It's difficult in the command-line tool, but easy using function calls since there's a function call specially intended for it: <http://www.sqlite.org/c3ref/column_name.html> Note that if your SELECT uses expressions, rather than direct references to columns, the results may not be what you expected. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users