Removing details and turning on highlighting to focus on certain aspects of the schema can be quite useful, especially if you choose to export the graph to discuss it with someone else.Ĭhanging the layout, reducing the number of tables and suppressing some information makes it easier to focus on structure.Ĭheck Viewing Table Relationships section for information about the references graph showing references for a specific table. Open the Object View tab (right-click -> Open in Tab).Locate the Tables node in the Databases tab tree.To zoom in on a specific table, you can also view table relationships for a specific table. You can however exclude unreferenced tables and/or manually select which tables to include on the graph. When opened on multiple tables, the graph shows all links between the tables you cannot choose to show inbound or outbound relations since all links are both outbound (from one table) and inbound (to some other table). You can also control whether the table names should be qualified with the schema/catalog in the graph. The GML format is saved using Save As in the right-click menu. It can also be saved s a GML (Graph Modeling Language) file that you can then open in the yEd tool from yWorks for further manipulation. The graph can be Exported to a file in JPG, GIF, PNG, SVG, PDF or EMF. bidirectional columns (used for both inbound and outbound links) and bidirectional links (where both source and target tables are selected) are orange.primary key columns and inbound links are red.foreign key columns and outbound links are green.If you choose the Hierarchical layout and select Links to Columns and Highlight Links, the graph will for all selected table nodes color code links and columns to indicate usage: dot file (or an input file for PlantUML) for a DB schema via a JDBC connection. GitHub - eska-muc/dbvisualizer: A tool which creates a GraphViz. Links to Columns ) are only available in Hierarchical layout. dot file (or an input file for PlantUML) for a DB schema via a JDBC connection. Settings vary slightly depending on whether you are viewing relations for a single table or multiple tables, and some settings (e.g.
For instance, you can select how much information to include for each table in the graph: just the Table Name, the Primary Key column(s) or all Columns, which links to include, and whether or not to highlight links for selected tables. Layout settings can be changed in the Graph Control area, which is shown or hidden with the settings toggle button in the toolbar. You can view relations to/from one or more tables in different graph layouts: Hierarchical, Organic, Orthogonal, or Circular. Use the References graph to see how tables are related to other tables through Foreign Keys.
0 kommentar(er)
