Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Sybase Central » SQL Anywhere 16 plug-in

 

Viewing entity-relationship (ER) diagrams

You can view an entity-relationship diagram of the tables in a database using Sybase Central. You can also import and export the layout of the ER diagrams.

Prerequisites

You must have PUBLIC system role.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to a database.

  2. Select the database, and then click the ER Diagram tab in the right pane to see the diagram.

  3. Click File » Choose ER Diagram Tables, and specify the tables to appear in the ER diagram.

  4. Click OK.

  5. (Optional) Change the tables that appear in the diagram by adjusting the filtering set for the database.

    The tables that appear in the diagram are subject to the filtering set for the database. The tables are filtered by their owners. Click File » Configure Owner Filter.

  6. Arrange the objects in the diagram. Drag the objects to change the layout. The layout changes persist between Sybase Central sessions. You can also import a layout, by clicking File » Import Layout.

  7. (Optional) Double-click a table to see the column definitions for that table.

Results

The entity-relationship diagram is changed.

Next

Export the ER diagram by clicking File » Export Layout.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0