Customizing the database tree view
The Database tool window provides access to functions for working with databases and DDL data sources. It lets you view and modify data structures in your databases, and perform other associated tasks.
You can filter, group, and sort the database objects that are shown in the Database tool window for each data source and display only the objects that you need.
Synchronize the database state
If someone changed the remote database data or view, the local view of the database might differ from the actual state of the database.
To synchronize the database state automatically, in the Database tool window (), click the Data Source Properties button (
) and select the data source that you want to change. On the Options tab, select the Auto sync checkbox.
If the Auto sync checkbox is cleared, the view of the data source in the Database tool window () is synchronized with the actual state of the database only when you click the Synchronize icon (
) or press Ctrl+Alt+Y.
Filter objects from the toolbar
To select the necessary objects, use the Filter icon on the toolbar (
).
Filter objects with the object filter
Specify filtering options in the Object filter field on the Schemas tab of the Data Sources and Drivers dialog ().
Use the following pattern when you compose an expression for the Object filter field.
<type>:[-]<pattern>, where:
<type> might be an aggregate, collation, event, fdw, ftable, mview, operator, package, role, routine, sequence, synonym, table, user, view, vtable.
<pattern> is a regular expression.To exclude an item, prepend with - (minus). For more information about regular expressions, see Class Patterns at JavaTM 2 Platform Standard Edition 5.0 API Specification.
Consider the following examples that demonstrate the filter syntax:
-
f.*Show only objects whose names start with
f. -
table:[gh].*Show tables whose names start with
gorh, and all other object types. -
view:new_.*||routine:-[ps].*Show views whose names start with
new_, routines whose names start with any letters exceptpors, and all other object types.
Group data sources
To group, enable, or sort data sources, click the Show Options menu icon (
) on the title bar of the Database tool window and select the necessary options.
Assign a color to a data source
To have better differentiation between production and test databases, you can assign a color to a data source.
In the Database tool window (), click the Data Source Properties icon (
). Select the data source for which you want to assign a color.
Click the Choose color icon (
) and select a color.Click OK.
