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.
Advertisement
Answer
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).