Procedure documentation Creating a Synonym Locate the document in its SAP Library structure

Use

You can use SQL Studio to create synonyms for database tables.

Prerequisites

You have the necessary user authorizations and have user attribute NOT EXCLUSIVE*.

Procedure

1.       In the Catalog Manager select the database table that you want to create a synonym for, and choose Catalog Manager ® New ® Synonym.
A window for defining the synonym is opened.

2.       Enter a synonym name, and select whether the synonym is to be private or PUBLIC.

3.       Choose Synonym Definition ® Create Synonym.

Note

To export the SQL statement for creating the synonym to the SQL dialog, choose Synonym Definition ® Export to SQL Dialog.

*For an explanation of user authorizations and user attributes, see the Structure linkUser Concept section of the documentation The SAP DB Database System and the Structure linkAuthorization section of the Reference Manual: SAP DB.

For information on the syntax of CREATE SYNONYM statements, see the Structure linkCREATE SYNONYM Statement section of the Reference Manual: SAP DB.