Dennis Cote wrote:
> Fred J. Stephens wrote:
>> Is there a way to list the column names in a table from the SQLite
>> command line interface? I know .schema <table> will show them, but the
>> output seems like it would be difficult to parse so that only the column
>> names are shown.
>>
>
> See pragma table_info(table-name) at
> http://www.sqlite.org/pragma.html#schema
Thanks Denis,
Thats just what I needed. I wasn't familiar with the pragma statements.
Fred Stephens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
