15.12 - Finding Objects - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
15.12
created_date
August 2016
category
User Guide
featnum
B035-2042-086K
You can search for database objects in the Data Source Explorer that have names that match a text string you specify.
  1. From the Data Source Explorer, right-click the database or user in which you want to search for an object.
  2. Click Teradata > Find Objects. The Find Object dialog opens.
  3. For Search Value Enter the exact name of the object you wish to find. The search is case-insensitive. If you know or wish to enter only a portion of the object name, click Advanced Find to open the Advanced Find dialog where you can specify only a portion of the object name in your search criteria.
  4. Use the Object Type list to specify the type of database object you are searching for. If you wish to search more than one object type, click Advanced Find to open the Advanced Find dialog where you can specify several types of objects to search.
  5. Click Find.
    • If you used the basic Find Object dialog box to search, the Data Source Explorer tree expands to show you the first instance of an object it finds matching your criteria.

      You can press F3 or right-click the Data Source Explorer tree and click Teradata > Find Next to search for other objects that have the same name.

    • If you used the Advanced Find Objects dialog box to search, all results of the search are displayed in a tab of the Object Viewer.