The “Database Explorer” shows all databases defined in “Settings” menu.
Expanding any database node will reveal the schemas node for databases supporting multiple schemas, or the tables, views and synonyms nodes for databases supporting one schema. A table node can be expanded further to show the columns and indexes of the table.
For Oracle, DB2, Microsoft SQL Server, Sybase, MySQL and PostgreSQL databases, additional database objects, such as sequences, stored procedures, triggers and packages will be displayed based on whether the database supports these objects.
Filters can be defined in the Database Explorer to control what schema objects should be displayed. The following shows the “Filter Settings” dialog box for a Schemas node. You can invoke the dialog box by right click on a Schemas node and choose the ‘Filter Settings” menu option.
Similarly, you can define filters on tables, views, synonyms, sequences, stored procedures and packages nodes.