![]() You can see the option by clicking the down arrow beside the SQL button.Ĭlick the Download image icon to save the ERD diagram in a image formateĬlick this button to add a new table to the diagram. You can select the option With DROP Table if you wish to have DROP Table DDL statements beforeĮach CREATE Table DDL. With the generated SQL ready for execution. You need to click the down arrow beside the save button to see Save As.Ĭlick the Generate SQL icon to generate the DDL SQL for the diagram and open a query tool File Options ¶Ĭlick the Open File icon to load a previously saved diagram.Ĭlick the Save icon to perform a quick-save of a previously saved diagram, or to save theĬlick the Save As to open a new browser dialog and specify a new location to save the diagram. Hover over an icon on Toolbar to display a tooltip that describes the icon’s functionality. The option is enabled for the highlighted icon and is disabled for the grayed-out icon. The ERD Tool toolbar uses context-sensitive icons that provide shortcuts to frequently performed tasks. To close a copy of the ERD tool, click the X in the upper-right hand corner of the tab bar. You can open multiple copies of the ERD tool in individual tabs simultaneously. Generate the database diagram for an existing database.ĭrag and drop tables from object explorer to the diagram. Generate ready to run SQL from the database design. Save the diagram and open it later to continue working on it. The ERD Tool allows you to:ĭesign and visualize the database tables and their relationships.Īuto-align the tables and links for cleaner visualization. ERD can give sufficient information for the database administrator to follow when developing and maintaining the database. ![]() Note: graphics/settings can be also copied and applied to other objects easily.The Entity-Relationship Diagram (ERD) tool is a database design tool that provides a graphical representation of database tables, columns, and inter-relationships. Of course, you can also edit any object by double clicking its graphical representative and change the text color or background color on the tab Graphics. To change colors, select an object and specify values in the right-side panel. PostgreSQL ER diagram and on the selected object levelĬolor for the selected table, composite type, enum, domain, function and other objects can also be specified in section Graphics. Change background color, relationship color and choose the relationship mode etc. Graphics on the diagram levelĬlick the diagram area to display diagram properties in the right side panel. Then click the tab Graphics and change the colors or other settings. To open the modal form, double-click the project name. The graphics settings can also be changed on the Project form. If you wish to maximize the diagram area, close the side panel. Then change the colors in section Graphics. for easier recognition of the project you currently work with), click the ER diagram area to make sure no object is selected. If you wish to change background color, line color or footer color (e.g. ![]() Colors and graphics defined on the project level Global graphics can be specified on a project level, you can modify colors on diagram level and properties can be modified also on selected object level. ![]() Graphics for PostgreSQL entity relationship diagrams (ER Diagram) can be defined on three levels.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |