windows - Output All SQLite3 Database Tables in Command Line Shell -


i trying use sqlite3 command line shell application print out tables in database.

my problem: when type command .tables nothing gets print out? unsure connecting/opening database because application doesn't print out status such 'opened db' or anything.

one thing know sure database file exists , contains tables , rows. know because c# application updating , querying db fine.

below commands. how can print out databases tables? doing wrong?

enter image description here

full size picture

your .open created database somewhere else.

use command prompt, , run instead:

sqlite3.exe "full_filename_of_your_db_file" 

this works me.

--

edit: alternatively, .open single quote can job

.open 'full_filename' 

Comments

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

Installing Android SQLite Asset Helper -

Qt Creator - Searching files with Locator including folder -