Show TOC

Creating a View from a SynonymLocate this document in the navigation structure

You can create views from synonyms in the same way as for tables. The view query displays the content of the object aliased by the synonym.

Procedure

  1. Ensure that no objects are selected in the diagram and select Start of the navigation path Tools Next navigation step Create View End of the navigation path to open a selection box listing all the available objects in the model.
  2. Click the Synonyms tab and select one or more synonyms to add to the view.
  3. Click OK. The view is created in the diagram.

    For example, the ORDERS_PROD_DEPT table has a synonym ORDERS:

    If you create a view for the ORDERS synonym, the view query displays the select order of the table content:



    For more information about views, see Views (PDM).