Output All SQLite3 Database Tables in Command Line Shell

Question

I am trying to use the SQLite3 Command Line Shell application to print out all tables in my database.

My Problem: When I type the command .tables nothing gets print out? I am unsure I am even connecting/opening the database because the application doesn't print out any status such as 'opened db' or anything.

One thing I know for sure is that my database file exists and contains tables and rows. I know this because my C# application is updating and querying the db just fine.

Below is my commands. How can I print out all my databases tables? Am I doing something wrong?

enter image description here

Full Size Picture

cshu · Accepted Answer · 2014-06-26 01:53:10Z

1

Your .open probably created another database somewhere else.

Use a command prompt, and run it like this instead:

sqlite3.exe "Full_filename_of_your_db_file"

This works for me.

--

Edit: Alternatively, .open with single quote can also do the job

.open 'Full_filename'

edited Jun 26, 2014 at 1:53

answered Jun 26, 2014 at 1:38

cshu

5,98432 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Output All SQLite3 Database Tables in Command Line Shell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related