Documentation Home
MySQL Workbench Manual
Related Documentation Download this Manual
PDF (US Ltr) - 17.0Mb
PDF (A4) - 17.0Mb


9.3.2.1 Adding a Table

The tools in the vertical toolbar on the left of theEER Diagram tab are used for designing an EER diagram. Start by creating a table using the table tool. The table tool is the rectangular grid in the middle of the vertical toolbar. Mousing over it shows the message,Place a New Table (T).

Clicking this tool changes the mouse pointer to a hand with a rectangular grid. Create a table on the canvas by clicking anywhere on theEER Diagram grid.

Right-click the table and chooseEdit in New Window from the pop-up menu. This opens the table editor, docked at the bottom of the application.

The table name defaults totable1. Change the name by enteringinvoice into theName: field. Changes here affect the name of the tab in the table editor and the name of the table on the canvas.

PressingTab orEnter while the cursor is in the table name field selects theColumns tab of the table editor and creates a default column namedidinvoice.

PressingTab orEnter again sets the focus on theDatatype list withINT selected. Notice that a field has been added to the table on the EER canvas.

PressingTab yet again and the focus shifts to adding a second column. Add aDescription and aCustomer_id column. When you are finished, close the table editor, by clicking thex button on the top left of the table editor.