Re: [sqlite] List Columns

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 will show them, but the >> output seems like it would be difficult to parse so that only the column >> names are shown. >> > > See pragma

Re: [sqlite] List Columns

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 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 h

[sqlite] List Columns

Is there a way to list the column names in a table from the SQLite command line interface? I know .schema will show them, but the output seems like it would be difficult to parse so that only the column names are shown. Thanks Fred Stephens ___ sqlit