![]() 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. |