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?
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
Post a Comment