Background documentationSynonym Name (synonym_name) Locate this document in the navigation structure

 

A synonym name (synonym_name) identifies a synonym for a table name. Synonyms are useful for abbreviating long or complicated table names.

Structure

Syntax Syntax

  1. <synonym_name> ::=
      <identifier>
End of the code.

The identifier may not exceed 32 characters in length.

Explanation

A synonym may be used in place of the old name at all times. Since synonyms are user-specific, a user identification does not have to be entered when a synonym is specified. If you access tables belonging to a different database user, you do not have to specify the user name before the table name if you use the synonym.

Multiple synonyms can be assigned to one table. They cannot be loaned to other database users. If the synonym is not a PUBLIC synonym, it is known only by one database user or user group. A PUBLIC synonym is known by every database user and user group.