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

Reply via email to