Results of Defining Structures Using SQL Statements › CREATE SYNONYM Statement

CREATE SYNONYM Statement

CREATE SYNONYM synonym-name FOR table-name (or view-name)

Creates a synonym. The following are the significant SYNONYM entity-occurrence attributes defined:

• AUTHID= The supplied or default schema (authorization ID).
• ENTITY-NAME= An internally generated unique name consisting of the schema (the AUTHID) followed by a hyphen and the name specified in the CREATE statement (the name must be unique— see the Occurrence Names Created from SQL Names section in the CA Datacom Datadictionary User Guide for details on actions taken by CA Datacom Datadictionary to create unique names).
• SQLNAME= The synonym-name provided in the CREATE SYNONYM statement.

CA Datacom Datadictionary creates relationships to associate the table or view with its synonyms.