Finding where schemas, tables, and columns are used in SQL statements in Java applications by using the Data Source Explorer

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:

  1. In a single database connection in the Data Source Explorer, highlight the schemas, tables, and columns that you are interested in.
  2. 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: Refresh with projects in workspace


Feedback