Partially Qualified Table Names

Partially qualified table names can be one-part or two-part names. A two-part table name consists of the table-identifier qualified by the authid, and implicitly qualified by the location-name of the current location.

A one-part table name consists of the table-identifier only, which is implicitly qualified by the location-name of the current location, and the Current SQLID special register. The value of the Current SQLID special register is determined by the following rules:

Note:

Aliases and synonyms can be used for alternative names for a table or view. Aliases can be used to assign alternative names for tables and views that are not in the current location. Synonyms can only be used to rename tables or views in the current location.