Is there a scripting function to list all the tables in a database connection .?
How to get all the table names listed in a Database Query Browser via scripting ?
Is there a scripting function to list all the tables in a database connection .?
How to get all the table names listed in a Database Query Browser via scripting ?
Not specifically scripting, but the SQL standard calls for DBs to implement the information_schema schema, with this kind of metadata. In the database query browser, start with this:
SELECT * FROM information_schema.tables
IIUC, you might get filtered responses if your connection credentials lack permissions.
Exactly what I was looking for. Thanks.