Deleting SQL Objects › Dropping a Synonym

Dropping a Synonym

Use DROP SYNONYM to remove a synonym from the CA Datacom Datadictionary. Dropping a synonym does not affect the table or view referenced by the synonym. All application plans that reference the synonym are invalidated.

Enter the DROP 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.

Example Source Member

The following example shows the DROP SYNONYM statement.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                                 Source Panel                               S01S
            EDIT     Member: DSYNONYM  Output Line Limit: 01000
                     Person: JONES
             Current Authid: JONES
                Description: DROP SYNONYM PROJECTS
 -------------------------------------------------------------------------------
 ====== ========================== T O P =======================================
 000001 drop synonym projects;
 ====== ======================= 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 DROP statement is required, as is the keyword SYNONYM. The keyword must be followed by the name of the object you are dropping.

Once this source member is executed, you cannot recall the synonym definition. If you want to use this synonym again, you must re-create it.

See DROP for more information on the syntax of the DROP statement.

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

• Enter additional SQL statements. Place a semicolon (;) after each complete statement.
• Press PF9 (EXECUTE) to execute the source member. CA Datacom Datadictionary responds with the Output Panel which shows the results of the SQL processing.
• Press PF2 (END) to obtain an SQLMAINT Panel where you can select another option.
• Press the Clear key to return to the Interactive SQL Service Facility Panel where you can choose another option.

Example Output Member

When you execute the statement, you receive a Output Panel similar to the following example:

 =>
 =>
 =>
 
 --------------------------------------------------------------------------- >>>
 Interactive SQL Service Facility                                       SQLMAINT
 
                                 Output Panel                               S01O
              EDIT     Member= DSYNONYM
                  Description: DROP SYNONYM PROJECTS
 -------------------------------------------------------------------------------
 ====== ========================== T O P =======================================
 000001 (OUTPUT CREATED FROM SOURCE MEMBER DSYNONYM)
 000002 drop synonym projects;
 000003 ---------+---------+---------+---------+---------+---------+---------+--
 000004 STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
 000005 ---------+---------+---------+---------+---------+---------+---------+--
 000006 SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72
 000007 NUMBER OF INPUT RECORDS READ IS 0001
 000008 NUMBER OF SQL STATEMENTS PROCESSED IS 0001
 ====== ======================= 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

To exit from the Output Panel, you can perform one of the following:

• Press PF2 (END) to obtain an SQLMAINT Panel where you can select another option.
• Press PF12 (ALTERNATE) to display the Source Panel.
• Press the Clear key to return to the Interactive SQL Service Facility Panel.