daniel civello wrote:
Hi all -- I'm having trouble understanding how to get a list of tables and the column
names that are in a database.
I've successfully attached a database via the sqlite command line, and I know a few
queries which run against the database successfully, so I know it's set up correctly.
Now, how do I get a list of the tables and columns? I'm basically wondering if there's a
'show tables' or 'desc <table>' command like in mysql.
.tables -- for a list of tables; note no ';'
.schema <table> -- for the schema of a particular table
.help -- reminds you of the above
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
