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. thanks! -daniel
