Viewing entity-relationship diagrams from the SQL Anywhere plug-in

When you are connected to a database from the SQL Anywhere plug-in, you can view an entity-relationship diagram of the tables in the database. Select the database, and then click the ER Diagram tab in the right pane to see the diagram.

An entity-reference diagram of the sample database as seen in Sybase Central.

When you rearrange objects in the diagram, the changes persist between Sybase Central sessions. Double-clicking a table takes you to the column definitions for that table.

The tables that appear in the diagram are subject to the filtering set for the database. Filtering is done by owner.

To change the tables included in the entity-relationship diagram

  1. Select the database in the left pane of Sybase Central, and then choose File » Configure Owner Filter.

    Select the database users whose tables you want to see in the entity-relationship diagram, and then click OK.

  2. Choose File » Filter Objects By Owner.

  3. Click the ER Diagram tab in the right pane.

    The entity-relationship diagram appears.

  4. Choose File » Choose ER Diagram Tables.

    The Choose ER Diagram Tables window appears. This window lets you further customize the tables that appear in the entity-relationship diagram.

    Use the Add and Remove buttons to customize the tables that appear in the Selected Tables list.

See also
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0