Chapter 13 Managing Database Access

Creating a view for a synonym

You can create views for synonyms in the same way as you create views for tables. The view query displays the content of the object used for the synonym. For example, table ORDERS_PROD_DEPT has a synonym ORDERS:

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

To create a view from a synonym:

1. Make sure there is no symbol selected in the diagram and select Tools→Create View.
   
   A Selection dialog box appears.
2. Click the Synonyms tab to display the list of synonyms of tables or views to select.
3. Select one or several synonyms and click OK.
   
   The view is created with a symbol in the current diagram.

Copyright (C) 2005. Sybase Inc. All rights reserved.