Previous Topic Next topic Print topic


The Query Tab

The Query tab allows you to specify default options for working with Queries. These options can be overridden for a particular query when you are editing the query. See also the section titled Query Run Tab.

3 Part Names If checked, queries are defined using fully qualified table names in the format location.authid.table-name.
2 Part Names If checked, queries are defined using 2-part table names in the format authid.table-name.
Unqualified Names If checked, queries are defined using unqualified table names.
Show Table Names If checked, a row is added to the Query Conditions Grid on the Query Design window to show the table where each column resides. This feature is especially helpful when your query joins two or more tables.
Foreign Keys If checked, the Query Design window automatically defines joins between the columns of any tables that are involved in a foreign key relationship
Primary Keys with Like Name If checked, the Query Design window automatically creates a join condition between the primary-key columns in one table and any set of primary-key columns with the same names in another table in the query.
Like Column Names If checked, the Query Design window automatically creates a join condition between tables in the query that have columns with the same name.
Prohibit Cartesian Products If marked, returns an error if you try to run a join that does not have a WHERE condition involving the joined tables. This only applies to queries run from the Query Design Window.
Previous Topic Next topic Print topic