I am trying to list all tables under qnx qdb in sql. I am not able to get a suitable command. How do you list tables in a database in qdb. I am able to connect to the database but I do not know what tables are currently in it.
Asked
Active
Viewed 309 times
1
-
What is the database engine you use ?? What is the command you use in order to connect to the db ??? – Oleg Gopkolov Mar 07 '18 at 11:04
-
qdb. Its a qnx version of sqlite. I use qdbc -d
to connect. – preetam Apr 09 '18 at 18:38
1 Answers
0
Once you get your interactive session, type ? and hit Enter.
A possible alternative is to make a backup of the DB (qdbc -d <database> -B), which will give you a sqlite file that you can load using a sqlite viewer and use usual sqlite commands (in this case, .tables).
hairlessbear
- 341
- 3
- 11