We are using this command to get column names

pragma table_info("stores")

and we get

0|id|INTEGER|0||1
1|email|TEXT|0||0
2|title|TEXT|0||0
3|description|TEXT|0||0
4|location |TEXT|0||0
5|zip |TEXT|0||0

is there a command we can get just the names of the columns so we don't have to parse it ?

something like

id|email|title|description|location|zip

After a query such as "SELECT * FROM SomeTable" has been submitted sqlite3_prepare() and its sibs, with a SQLITE_OK return, the sqlite3_column{count,name,name16} APIs can be used to get those column names.

At this time, the sqlite3 CLI declines to show column names for empty result sets. So if "a command" means a dot command given to that tool, the answer is "No" at this time.

Something along these lines:

select group_concat(name, '|')
from pragma_table_info('stores')

echo 'pragma table_info("stores");' | sqlite3 yourDatabase.sqlite  | awk -F\| '{gsub(/^[[:space:]]+|[[:space:]]+$/,"",$2); printf "%s|", $2}'

What about

select name from pragma_table_info('stores');

it worked perfectly !!! thanks a lot!!!

Backlink to this question on stackoverflow: How to get a list of column names on Sqlite3 database?.