Chapter 3 Building Physical Diagrams

Creating a view for tables and views selected in the diagram

You can create a view for tables and views selected in the diagram. If the selected tables and views are linked by references or view references, their joins appear as conditions in the view query.

To create a view for tables and views selected in the diagram:

1. Select one or more tables and views in the diagram.
   
   
      Multiple table selection
   You can select multiple tables and views by holding down the SHIFT key while you select tables in the diagram.
   
   
2. Select Tools→Create View.
   
   A view symbol appears in the diagram. It displays all the columns in each of the tables and views selected for the view. The names for the tables and views appear at the bottom of the view symbol.
   
3. Double-click the new view symbol to display the view property sheet.
   
4. Type a name and a code for the view.
5. Click OK.

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