[sqlite] See table structure

Hi List, In SQLite, to see the table structure which command can I use? (as in Oracle's desc table name ) Thanks, Lloyd __ Scanned and protected by Email scanner - To

Re: [sqlite] See table structure

from the command line in sqlite3: .schema table name Lloyd wrote: Hi List, In SQLite, to see the table structure which command can I use? (as in Oracle's desc table name ) Thanks, Lloyd __ Scanned and protected by Email scanner

Re: [sqlite] See table structure

Lloyd [EMAIL PROTECTED] wrote: Hi List, In SQLite, to see the table structure which command can I use? (as in Oracle's desc table name ) You can use select * from sqlite_master; and there is specific information available by the pragma command: http://sqlite.org/pragma.html d