How to find table in a database with Aqua Data Studio

This article will show you how to find tables in Aqua Data Studio.

Option 1: Object Search

Step 1 - open the Search window

From toolbar select Tools -> Object Search option. Fig. 1. Object search in Tools menu

A new window with connection chooser will appear. Select in which database instance you want to search for the table and click OK.

Fig. 2. Server instance chooser

Or make the Server Panel visible by clicking Window -> Show/Hide Server Panel (Fig. 3 [2]) or by clicking on the Servers tab (Fig. 3 [1]).

Fig. 3. Server Panel tab [1], Server Panel visibility option in toolbar

In the Server Panel, right click on the database in which you want to search for a table and select Tools -> Object Search.

Step 2 - run the search

In the Object Search window set::

  • in the Database section, check which databases should be searched
  • in the Schema section, check which schemas should be searched
  • in the Object Type section, check the Tables box
  • in the Object Search section, check the Object Name box
  • in the Source Search section, uncheck all boxes

When you finish, provide the table name in the Search for section and click the Search button. If a match is found, it will be displayed in the same window.

Fig. 4. Object Search window

Option 2: Search in Server Panel

Make the Server Panel visible by clicking Window -> Show/Hide Server Panel (Fig. 3 [2]) or by clicking on Servers tab (Fig. 3 [1]).

Now, to search for the tables, you must expand only [your database/schema name] -> Tables branches.
When you type text in the Server Panel, Aqua will look for table name starting with provided text. If there are more than one table with the provided prefix, you can navigate to the next found result with arrow keys.
Note that Aqua will search for provided string in all visible elements.

Fig. 4. Searching in Server Panel

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.