>> Hi Simon, >> 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. In any case, it's nit possible to convert an ad hoc query (ie not known beforehand) into one that returns no rows. > 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> It would be great to see a pragma or built in SQL function that returned the column headers of a given query. > Thanks, Tom BareFeet _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users