On Thu, 27 Apr 2006, Dan Baker wrote:
[...]
It appears to return 6 columns of data per table-column. I believe they are
as follows:
[1] = column# (0...)
[2] = column name
[3] = column affinity/type
[...]
[4] = flag: is the column NOT NULL?
[5] = default value of the column
[6] = flag: is this column part of the table's PRIMARY KEY?
Can someone point me to a good place about what is coming back?
The official documentation at http://www.sqlite.org/pragma.html#schema
lists most of this information. Also note the names of the columns
returned by the PRAGMA, which are helpful:
$ sqlite3
SQLite version 3.3.5
Enter ".help" for instructions
sqlite> .headers on
sqlite> PRAGMA table_info(sqlite_master);
cid|name|type|notnull|dflt_value|pk
[...]
cu,
Thomas