Re: [sqlite] PRAGMA table_info documentation

2013-02-02 Thread Petite Abeille
On Feb 2, 2013, at 7:32 PM, chojra...@gmail.com wrote: > I'd like to ask about contents of last column in result of PRAGMA > table_info in SQLite 3.7.15.1 because it is not documented ( > http://www.sqlite.org/pragma.html#pragma_table_info). > It looks as if the value is '1', the column is in

Re: [sqlite] pragma table_info(...) documentation?

2006-04-27 Thread Thomas Chust
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

Re: [sqlite] pragma table_info(...) documentation?

2006-04-27 Thread Jay Sprenkle
On 4/27/06, Dan Baker <[EMAIL PROTECTED]> wrote: > I'm needing to find some information about a table, and the table_info > pragma seems to be the right ticket. > > I've looked around, and failed, to find any documentation on this cool > pragma. > It appears to return 6 columns of data per

[sqlite] pragma table_info(...) documentation?

2006-04-27 Thread Dan Baker
I'm needing to find some information about a table, and the table_info pragma seems to be the right ticket. I've looked around, and failed, to find any documentation on this cool pragma. It appears to return 6 columns of data per table-column. I believe they are as follows: [1] = column#