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
- Select several objects of the same type (use Ctrl or Shift).
- 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.