Re: [sqlite] Re: Meta Information: How to retrieve the column names of a table ?

How can I get all the names of a table without doing a query against the table ? PRAGMA table_info(table-name); And it also works for views, as just found out by trial and error ;-) Is this standard SQL behavior ? -- cheers, Stef Mientki http://pic.flappie.nl

Re: [sqlite] Re: Meta Information: How to retrieve the column names of a table ?

Igor Tandetnik schrieb: Marten Feldtmann wrote: How can I get all the names of a table without doing a query against the table ? PRAGMA table_info(table-name); Thats it ! Thanks ! What's sqlite3_column_meta_data? It doesn't seem to be mentioned in

[sqlite] Re: Meta Information: How to retrieve the column names of a table ?

Marten Feldtmann wrote: How can I get all the names of a table without doing a query against the table ? PRAGMA table_info(table-name); I need all the names of columns within tables/views, the column index within the raw table. What's "column index" and "raw