Finding database objects that SQL statements refer to

When you are writing an SQL statement in a Java™ applications, you can quickly look up the properties of the database objects that the statement refers to.

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 look up the properties of a database object (such as a schema, table, view, or column) that an SQL statement refers to:

  1. In the SQL statement, click the name of the object.
  2. Right-click the name of the object and select pureQuery > Find In > Data Source Explorer.
  3. After the workbench highlights the object in the Data Source Explorer, open the Properties view.

Feedback