SQL Statements › CREATE SYNONYM › Description › Example

Example

The following example defines an alternative name, OUTDEPTS,for the table DEPTTBL. KWAN is the authorization ID of the user who owns DEPTTBL.

EXEC SQL
CREATE SYNONYM OUTDEPTS
FOR KWAN.DEPTTBL
END-EXEC