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

When you are connected to a database from the SQL Anywhere 12 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.

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

  3. Choose File » Filter Objects By Owner.

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

  5. Choose File » Choose ER Diagram Tables.

  6. In the Choose ER Diagram Tables window, use the Add and Remove buttons to customize the tables that appear in the Selected Tables list.

  7. Click OK.

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0