Skip to content

Filter database objects

Overview

In the Database Navigator and Database Object Editor, you can filter database objects to simplify the tree view. Filters apply to connections, schemas, tables, views, and other objects.

Info

A dots icon (...) next to a node name means that a filter is active on its subnodes.

Filter by object type

Use the dropdown next to the filter mode button to choose what types of objects to filter in the navigator tree:

Icon Filter option Description
Filter connections Filters connection nodes in the navigator tree.
Filter catalogs and schemas Filters catalogs and schemas.
Filter tables, procedures, etc. Filters leaf-level objects like tables, views, procedures, etc.

Start typing in the field to filter by name within the selected object type. Results update instantly.

You can use:

  • Exact names — for example, order
  • Wildcards (*) — for example, user*
  • Multiple values separated by |, ,, or space — for example, user*, order report|log

Tip

When filtering catalogs/schemas or tables/procedures, only expanded parts of the tree are included. Collapse unused sections to improve performance.

Filter by connection status

Use the toolbar in the Database Navigator to control which connections are shown:

Icon Filter option Description
Show all connections Displays all saved connections.
Show connected only Displays only currently active connections.

You can switch between these modes by clicking the icon.

Filter using the context menu

Right-click any object and use the Filter submenu:

Filter option Description
Hide [object name] Hides this object, shows all others.
Show only [object name] Shows only this object, hides others.
Toggle filter Inverts the current filter (hides visible, shows hidden).
Clear filter Removes the filter entirely.
Configure [objects] filter Available on folders like Tables or Indexes. Opens advanced filtering options. See Configure Filters.

Filter multiple objects at once

  1. Select several objects of the same type (use Ctrl or Shift).
  2. Right-click -> Filter -> Choose an option:
Filter option Description
Hide N objects Hides selected objects.
Show only selected objects Shows only selected objects, hides the rest.

To reset this filter, right-click the parent folder (with (...)), then click Filter -> Clear filter.