Creating SQL Objects › Creating a Synonym

Creating a Synonym

Use the CREATE SYNONYM statement to define an alternative name for a table or view. However, the table or view must be defined in CA Datacom Datadictionary before you can create its synonym. After defining a synonym, you can use it in place of the full qualified table or view name (authorization ID and table or view name).

You can define synonyms in the same schema as the tables or views. However, the schema must be represented by the current authorization ID for the session. You can define a synonym in your schema for a table or view that is listed in another schema.

Enter the CREATE SYNONYM statement in the numbered area of an EDIT Source Member Panel. See How to Submit SQL Statements for the steps to obtain the panel and an explanation of the fields on the panel. See CREATE SYNONYM for the syntax of the statement.