Listing all tables in a DB connection

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.

5 Likes

Exactly what I was looking for. Thanks.