How to list the tables in a SQLite database file that was opened with ATTACH?

sql database sqlite metadata
izb picture izb · Sep 17, 2008 · Viewed 1M times · Source

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Answer

Mark Janssen picture Mark Janssen · Sep 17, 2008

There are a few steps to see the tables in an SQLite database:

  1. List the tables in your database:

    .tables

  2. List how the table looks:

    .schema tablename

  3. Print the entire table:

    SELECT * FROM tablename;

  4. List all of the available SQLite prompt commands:

    .help

Related questions

Best way to work with dates in Android SQLite

I'm having some trouble working with dates on my Android application that uses SQLite. I have a couple questions: What type should I use to store dates in SQLite (text, integer, ...)? Given the best way to store dates how do …

Read More
Drop all tables command

What is the command to drop all tables in SQLite? Similarly I'd like to drop all indexes.

Read More
SQLite INSERT - ON DUPLICATE KEY UPDATE (UPSERT)

MySQL has something like this: INSERT INTO visits (ip, hits) VALUES ('127.0.0.1', 1) ON DUPLICATE KEY UPDATE hits = hits + 1; As far as I know this feature doesn't exist in SQLite, what I want to know is if there is any …

Read More