Select High-level qualifiers to specify whether or not you want to include high-level qualifiers in new SQL statements you create. High-level qualifiers will be included when High-level qualifiers is checked.

Including high-level qualifiers causes table names to be prefixed with a high-level qualifier appropriate for the database manager you specified. For example, when using IBM DB2, the table names are prefixed with the current database logon userid.

High-level qualifiers are only necessary in certain SQL statements. For example, say two different userids created tables in the same database with the same name, using IBM DB2. The only way to uniquely identify one of the tables, when not logged on as the userid that created it, is to prefix the table name with the userid that created it.

If high-level qualifiers are not necessary for a SQL statement, you may want to avoid using them so the table names are not unnecessarily long.

You can restrict the number of table names that appear in the SQL editors by setting the high level qualifier preference on the Database page of the preferences notebook.