The alternative name you want to use when referring to the table or view. The synonym name must not be identical to another synonym or to the unqualified name of a table or view in your default schema. The synonym name can be 1 to 18 characters if you specify the Preprocessor option SQLMODE=ANSI or SQLMODE=FIPS. If SQLMODE=DATACOM, the synonym name can be 1 to 32 characters.
Introduces the qualified name of the table or view for which you are creating the synonym.
Specify an authorization ID if you are creating a synonym for a table or view in a schema other than your default schema. Use a period (.) to concatenate the authorization ID to the table or view name (for example, auth-id.table-name).
Must name a table or view described in the CA Datacom Datadictionary. The synonym is defined only for your authorization ID, that is to say, the authorization ID of the CREATE SYNONYM statement when the statement is prepared.
|
Copyright © 2014 CA.
All rights reserved.
|
|