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

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.

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