Entering content frame

Synonym Name (synonym_name) Locate the document in its SAP Library structure

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

Syntax

<synonym_name> ::= <identifier>

Explanation

A synonym can be written anywhere instead of the old name. Since synonyms are user specific, a user identification does not have to be entered when a synonym is specified. If you access tables that belong to a different 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 users. If the synonym is not a PUBLIC synonym, it is known only by one user or user group. A PUBLIC synonym is known by every user and user group.

An error message is displayed if the name has more than 32 characters.

SQL Statements

CREATE SYNONYM Statement

RENAME SYNONYM Statement

DROP SYNONYM Statement

 

Leaving content frame