Search

Search walks the DB Explorer tree and highlights every object whose name matches your text, wherever it sits in the hierarchy. Unlike Filter, which hides or shows the immediate children of one container, Search looks recursively through databases, schemas, tables, columns, views, functions, and other objects at once.

Searching Everything

Click the Search icon in the DB Explorer view title, or run DBCode: Search from the Command Palette (Cmd/Ctrl + Shift + P). Type your text and press Enter. Matches are highlighted in place, with their parent nodes expanded so you can see where each one lives.

A summary row appears at the top showing what you searched for and how many matches were found. Click that row, or the clear icon on it, to remove the search. The title-bar icon also switches to a clear action while a search is active.

Searching One Connection or Database

When you have several connections with similar structures, for example a Test and a Production connection that share the same schemas, a search across everything surfaces the same object names in both and reads as duplicates.

To avoid that, right-click a connection or a database and choose Search. The search is confined to that subtree, so only matches inside the connection or database you picked are shown. The input box title tells you which one you are searching.

Loading As It Searches

The search descends into the tree and loads objects it hasn’t seen yet as it goes, so with Progressive Loading enabled it still finds objects in schemas and tables you have never opened, including columns of unexpanded tables. Searching a database that has never been opened connects and introspects it first.

Because a large schema can take a while, a Searching… row at the top shows where the search currently is, and matches stream into the tree as they are found. A Cancel search row sits below it, cancel keeps whatever has matched so far.

Searching Other Databases

A connection search only reaches the databases you have already opened. Any others are listed at the bottom under Databases not opened yet, click one to open, search, and add its matches to the results.

What Gets Searched

Search matches object names anywhere in the tree. Synonyms are matched by their own name but not followed to their target, so a search does not resolve every synonym. The title-bar search that covers every connection matches whatever is loaded or cached rather than loading each connection in full.

Related Features

• Filter - Show or hide the immediate children of a single container
• Quick Open - Keyboard-driven navigation and object lookup