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.
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 synonym is as easy as the following 4 steps:
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.