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. |