how to list all tables in qnx qdb

349 Views Asked by At

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.

1

There are 1 best solutions below

0
hairlessbear On BEST 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).