How to find table in a database with Toad for SQL Server

Bart Gawrych - Dataedo Team Bart Gawrych 2019-04-29

Table of Contents:


    In this article I will show you how to find table by name in Toad for SQL Server tool.

    Option 1: Using Find tool

    Use Find option - you can find it in main menu Tools -> Findor press F4 key.

    New opened window (Object Search) consists of multiple sections.

    1. In the Database section choose in which databases you want to search for a table.
    2. In Object types uncheck all except Tables (Right click -> Uncheck All to fast uncheck all).
    3. In the Conditions section, you can change search predicate. Uncheck all checkboxes in Deeper search section.
    4. Finally provide text to search in textbox and click on Search button (or Append to add new search results to current results).

    Option 2: Using Object Explorer

    To open Object Explorer navigate to View -> Object Explorer or press F8 key. In the opened window choose:

    1. switch to Tables tab
    2. provide a string to search for in Object Explorer filter section.

    You can use more advanced filtering options by clicking on the funnel icon next to search box.

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