Database Search

Go Up to Tools

The powerful Database Search tool lets you search for objects whose DDL contains a specified character string, across multiple databases.

Platform Availability

DB2 LUW	DB2 z/OS	MySQL	ORCL	PSTGRS *	SQL SVR	SYB ASE	SYB IQ
✓	✓	✓	✓	✓	✓	✓

To find instances of a string on multiple databases:

1. On the Tools menu, click Database Search. The Database Search Wizard opens.
2. Use the following table as a guide to understanding and modifying the settings on the panels of this wizard:

Panel	Settings and tasks
Select the datasources you want to search	Depending on the DBMS platform, you may also be able to further qualify by database, user, or schema.
Select the objects you want to search	Lets you specify the character string to search for, select a case matching setting, and specify the object types that are to be searched. Depending on the DBMS platform, searchable object types are defaults, foreign keys, functions, indexes, materialized tables, package bodies, packages, primary keys, procedures, rules, tables, triggers, unique keys, and views.

1. Click Finish to start the search.

A progress dialog box is displayed while the search runs. When the search completes, the results open in a Database Search window. The left pane lists all objects whose DDL satisfied the search. The right pane displays the DDL of a selected object. Lines containing the specified character string are flagged.

When viewing results, the following options are available from the Database Search window toolbar:

Button	Description
Search	Reopens the Database Search wizard with the most recent settings specified. This lets you further qualify settings for a new search.
Criteria	Opens a window displaying the case matching option and character string specified for the search.
Open	Opens the selected object in an object editor. For information on using object editors, see Modifying objects using editors.
Extract	Extracts the DDL for a selected object to a SQL editor window. For more information, see Using the SQL Editor.
Print	Lets you print the target object SQL.