Zoom Out: or Ĭhoose Regenerate ER Diagram from Refresh button. Same effect can be achieved with keyboard shortcuts: To zoom in or zoom out the selected area of the diagram, adjust the slider of the Overview pane. To delete a vertex or all vertices on a relation, right-click a relation and select Delete Vertex or Delete All Vertices from the pop-up menu. To add a vertex on a relation, right-click a relation and select Add Vertex from the pop-up menu. To delete a relation, right-click a relation and select Delete Foreign Key from the pop-up menu. To edit a relation, right-click a relation and select Design Foreign Key from the pop-up menu. Drag the source table field and drop to the target table field. To add a relation, click from the bottom toolbar. For the settings of different tabs, see Server Objects. The tabs and options in the designer depend on the diagram database type you have chosen. Note: Double-click a table in ER Diagram view will open the Table Designer, while double-click a table in List view and Detail view will open the Table Viewer. Hint: ER Diagram files are stored under Settings Location.ĭisplay table fields and relationships between tables in a database/schema. An ER diagram will be created automatically if the selected database/schema contains tables. Select View -> ER Diagram from the main menu or click at the bottom right hand corner. Other database objects only provide List view and Detail view. It also allows adding foreign key constraints to tables directly. In this ER Diagram view, you can view table fields and relationships between tables in a database/schema graphically. To change the display columns of properties, select View -> Choose Columns from the main menu and select display columns for different objects from the pop-up window.īesides List and Detail views, Navicat enhances table viewing to a new ER Diagram view. To change to Detail view, select View -> Detail from the main menu or click at the bottom right hand corner. You can select View -> List from the main menu or click at the bottom right hand corner.ĭetail view shows several properties of objects in columns. By default, Navicat uses the List view in the Object List pane. Navicat provides three types of views for objects in the main window.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |