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
-
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
documentation.
Sorry, this function c
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 table"? I'm not familiar with t
3 matches
Mail list logo