How to find table in a database with SQL Workbench/J

Rene Castro - Dataedo Team Rene Castro 2018-08-09

Table of Contents:


    In this tutorial I would like to show you how you can find table in a database with SQL Workbench/J - a free, DBMS-independent, cross-platform SQL query tool.

    There are two ways to find table.

    Option 1: Database Explorer

    First option is to find it in Database Explorer.

    To open explorer go to Tools menu and choose Show Database Explorer.

    Explorer lists all objects in the database. You can find for specific table or object using quick filter at the top. Type in part of the table name in the field on the right and confirm with enter. Objects will be filtered to the ones containing provided text.

    You can also use object type filter to further narrow down the results.

    Option 2: Database Object tree

    Second option is to use Database Object tree.

    To Object tree go to Tools menu and choose Show DbTree.

    It is visible in statement editor on the left side of screen. If you don't see it go to existing statement tab or open a new one with ctrl+T.

    To find a table use filter field at the top. Type in part of the name and confirm with enter.

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

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept