Create Relationships, etcĬreate relationships and any other configurations by using the various tabs: The “Foreign Keys” tab enables you to set up relationships between tables. Also specify whether it’s a primary key column, allows null values, auto-increment value, and more. After adding a table, create each column and set its data type. Add Tables, ColumnsĪdd tables by clicking Add Tables, then add/configure their columns in the bottom pane: Configuring a table when creating a model using MySQL Workbench. You can then add tables, columns, views, routines, and more. Create a New SchemaĬreate a new schema by clicking the + icon next to Physical Schemas: Clicking the “+” sign next to “Physical Schemas” adds a new schema. Create a New ModelĬlick File > New Model from the menu: Selecting “New Model” from the File menu will enable you to create a new database model and/or diagram. You can rearrange the tables to a more suitable layout by clicking and dragging.īelow are screenshots for the above steps. Create a diagram by clicking Model > Create Diagram from Catalog Objects.Create relationships and any other configurations by using the various tabs.Add tables by clicking Add Tables, then add/configure their columns in the bottom pane.Create a new schema by clicking the + icon next to Physical Schemas.To create a new database diagram using MySQL Workbench:
0 kommentar(er)
