Cross Reference

Previous Next

When the SQL statement associated with certain objects is checked by pressing the Check button in their respective definition winnow, repository tables are filled with information about the tables, columns, relationships, methods and external sets that are used in the SQL statement.. These repository tables are called SQL Object tables. Whenever you make a change to an item that is used in the SQL statement for that object, for example: deleting a column, the cross reference feature uses the information in the SQL Objects table to set all objects (constraints, SQL Tasks, etc.) that use that item to incorrect.

Object types for which information is stored in SQL Objects tables when they are checked are:

Table Constraints

Domain Constraints

Logical Views


SQL Tasks

Import Tasks

External Sets

Component Constructors

Web Service Providers

Cross reference information is available in read-only form in the SQL Objects tab pages of the Logical Views, Relationships, External Sets, and the various Tables info windows. This information can be used to quickly find where a particular item is used, and in some cases where it is used in a SQL statement, for example: in a WHERE clause, or the out list of a query, etc.