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.
You must have PUBLIC system role.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to a database.
Select the database, and then click the ER Diagram tab in the right pane to see the diagram.
Click File » Choose ER Diagram Tables, and specify the tables to appear in the ER diagram.
(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.
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.
(Optional) Double-click a table to see the column definitions for that table.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|