You can use the
Data Source Explorer to find database objects
in the SQL statements in your applications. You might want to conduct
this type of search if, for example, you need to know how changes
to database objects might affect an application.
Before you begin
The Java code
in which the SQL statements appear must be part of a Java project that is enabled for development
with pureQuery.
Procedure
To use the Data Source Explorer to find SQL statements
that refer to particular database objects:
- In a single database connection in the Data Source Explorer,
highlight the schemas, tables, and columns that you are interested
in.
- Right-click the selection of database objects
and select Find
Reference in SQL Outline.
Results
The workbench filters the content of the SQL
Outline view to show only those SQL statements that refer to the database
objects that you are interested in.
At the top of the view appears
a line that describes the current filter. If you want to remove the
filter, click this button at the top of the view: 