Previous Topic: Naming the SynonymNext Topic: Example Output Member

Creating SQL Objects › Creating a Synonym › Example Source Member

Example Source Member

The following example shows the CREATE SYNONYM statement.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                                 Source Panel                               S01S
            EDIT     Member: PROJSYN   Output Line Limit: 01000
                     Person: JONES
             Current Authid: JONES
                Description: CREATE SYNONYM PROJECTTBL
 -------------------------------------------------------------------------------
 ====== ========================== T O P =======================================
 000001 create synonym projects for ted.projecttbl;
 ====== ======================= B O T T O M ====================================
 
 
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

The statement CREATE SYNONYM is required and must be followed by the name of the synonym, which is PROJECTS in this example.

The FOR clause specifies the authorization ID of the table's schema and the name of the table. The authorization ID and table name are concatenated by the period (.) indicating this is the qualified name of the table. The table name must be qualified in this case since it is not in the schema identified by the authorization ID (JONES) which is the default authorization ID.

For more information on the syntax of the CREATE SYNONYM statement, see CREATE SYNONYM.

After placing your SQL statement in the numbered line area on the Source Panel, you can perform the following: