Dropping Synonyms

A synonym is not dropped until you exit the Alter Table dialog box. Before you exit this dialog box, be sure you have made all appropriate changes and wish to save the table specifications.

To drop a synonym:

  1. Display the Alter Table dialog box for the table on which the synonym is defined.
  2. Click the Options button to display the Table Options dialog box.
  3. Highlight a synonym in the Synonyms group box and click the Drop button. The Table Options dialog box displays the synonym with a - sign preceding it to indicate that it will be dropped.
    Note:

    If you mark a Synonym name and then realize you want to keep it, before exiting the Alter Table dialog box, double click the name of the Synonym to display the Drop Synonym dialog box. Then click the Undo button. The - sign will be removed, and the original synonym will remain intact.

  4. Click OK from the Table Options dialog box and click OK in the Alter Table dialog box to drop the synonym.
  5. Click OK to confirm altering the table.