Stef Mientki <[EMAIL PROTECTED]> wrote:
Igor Tandetnik wrote:
Stef Mientki
<[EMAIL PROTECTED]>
wrote:
is there an SQL statement to get the field-names of empty tables ?
PRAGMA table_info(tableName);
I had seen that command,
but I wrote something about that these commands could only be run from
the command line.
No. You can run it just like you run any statement, and it produces a
resultset with one row for each column in the tableName table.
sqlite3 command line application is not black magic. It uses public
SQLite API only. You can look at the source code and see for yourself,
if you are so inclined.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
