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.

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

• Creating databases in SQL Anywhere