subject:"\[sqlite\] See table structure"

Re: [sqlite] See table structure

2006-10-20 Thread David Crawshaw

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

Re: [sqlite] See table structure

2006-10-20 Thread Jim Dodgen

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

[sqlite] See table structure

2006-10-20 Thread Lloyd

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