Synonyms

Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym. Synonyms provide both data independence and location transparency. Synonyms permit applications to function without modification regardless of which user owns the table or view and regardless of which database holds the table or view. Using dbForge Fusion you can create, edit and delete synonyms.

Creating a Synonym

  1. In the Database Explorer window, right-click the Synonyms folder, and then click New Synonym in the shortcut menu.
  2. Provide a synonym name in the opened dialog box. Optionally, you can change schema for the object.
  3. Click Create.

A new document appears with template in Design view. Choose synonym parameters and save the document to have the synonym created. You can switch to Text view to inspect generated SQL query.

Editing a Sequence

  1. In the Database Explorer window, expand the *Synonym folder.
  2. Right-click a required sequence, and then click Edit Synonym in the shortcut menu.

Editing a synonym is as easy as the following 4 steps:

  1. Choose whether the object is located in the same database or remote one.
  2. For local database choose object type, for the remote one choose database link.
  3. Choose an object schema.
  4. Choose an object name.

For local database the available names are automatically suggested in drop-down lists. In case of remote database you have to input object’s schema and name yourself.