You can retrieve a list of all tables currently defined in the store using the SHOW TABLES statement:

SHOW [AS JSON] TABLES

where AS JSON is optional and causes the resulting output to be JSON-formatted.