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.