A public synonym, used without a qualifier, exists in the default catalog. The public synonym may be qualified by a catalog name, in which case the synonym must exist in the set of synonyms defined for that particular catalog.

A private synonym must always be qualified by at least the name of the schema where that synonym exists. A private synonym, used with only a schema qualifier, exists in the default catalog.