Some basic options for the tools of Database Workbench can be found in this panel.
The Tools Settings
SQL & Code Catalog
All these options are pretty self explanatory.
Shared Catalogs are stored in the folder you select with the button. The shared catalogs can be shared between multiple Database Workbench installations. It makes sense to put the shared catalogs folder on a network drive.
Describe Companion
All these options are pretty self explanatory.
Statement Recorder
Record DDL statements |
Record metadata statements like CREATE TABLE etc... This includes statements issued by the Object Editors and allows you to create an "upgrade script". |
Record DML statements |
Record data statements (UPDATE, INSERT, DELETE). Note that any changed made via data-grids are NOT recorded. |
For more information on the Session or Statement Recorder, see Session Recorder.