Table of Contents:


    Follow us

    How to find table in a database with Aqua Data Studio

    Bart Gawrych - Dataedo Team Bart Gawrych 2019-04-12 2019-05-09

    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

    Share this article

    0
    There are no comments. Click here to write the first comment.