Data object filters

You can create, view, change, and remove filters.

You can use filters to exclude data objects (such as tables, schemas, stored procedures and user-defined functions) from your view. Only the data objects that match the filter condition will be shown.

There are two types of Data perspective filters: data object filters and JDBC connection filters.

A data object filter excludes data objects from the tree view of the database. These filters can be set or removed at any time. You can apply data object filters to your views in the Data perspective.

JDBC connection filters are set when you create a connection to a database by using either the New Database Connection wizard or the Database Connection page of another wizard. These filters can be edited for an existing connection.

Tip: Connections to a remote server for all database vendors can take a considerable amount of time. To reduce the time for remote connections, configure appropriate connection filters by excluding parts of the database that are not required.

Creating a data object filter
You can create a data object filter at any time. A data object filter excludes data objects (such as, tables, schemas, stored procedures and user-defined functions) from the Data Definition view or the Database Explorer view.

Viewing and changing a data object filter
You can view and change a data object filter to modify the filtering conditions for data objects in the Data perspective.

Removing a data object filter
Remove a data object filter from your views in the Data perspective so that you can see filtered objects in the tree view.

 

Parent topic

Overview of the Data perspective