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 ) or by clicking on the Servers tab (Fig. 3 ).
Fig. 3. Server Panel tab , 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 ) or by clicking on Servers tab (Fig. 3 ).
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