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 table-column. I believe they are > as follows: > [1] = column# (0...) > [2] = column name > [3] = column affinity/type > [4] = ? > [5] = ? > [6] = ? > > Can someone point me to a good place about what is coming back?
Don't forget about this: select * from sqlite_master; --- SqliteImporter: Command line fixed and delimited text import. http://www.reddawn.net/~jsprenkl/Sqlite Version 1.10 released with C++ source
