metadata query

[Darshak]

Hi Thomas,

 Is there way to get query being executed by WB to get metadata info ?

e.g. dbExplorer - Left panel - displays List of objects, type of object, etc.

Below settings are already enabled in OPTIONS.

Log all SQL statements as INFO message

Log internal SQL statements as INFO message

 

Thanks,

Darshak

[Thomas Kellerer]

Ah, sorry.
The options dialog is misleading this will be logged on DEBUG level, so the option needs to be enabled and the log level needs to be DEBUG

I will change that.

However, many things are retrieved through the JDBC driver, so SQL Workbench doesn't really run a SQL query.
Those are e.g. the list of tables/procedures, table columns, indexes and foreign keys.

Regards
Thomas

[Darshak]

Hi,

I have enabled Log Level to DEBUG (in options). 

I got asked some info / clue from it as few metadata queries are available in log.

Thanks