MySQL :: MySQL Workbench Manual :: 9.3.4.1 Creating a New Table

MySQL Workbench Manual / ... / Creating a New Table

9.3.4.1 Creating a New Table

Create a new table by double-clicking the Add Table icon in the Physical Schemas panel, as the next figure shows. This action opens the table editor docked at the bottom of the application. You can undock or dock this editor in exactly the same way as the schema editor window.

Figure 9.33 Model: Creating A New Table

Content is described in the surrounding text.

Initially, the table name defaults to 'table1' in the table editor. The following figure describes the available actions.

Figure 9.34 Model: Editing Table Values

Content is described in the surrounding text. Available actions include: double-click the schema to edit, add an additional schema, toggle collation/engine editor, add table columns, and select additional tabs.

In the previous example, columns were added using the Columns tab. Clicking an empty row will add a new column, and clicking an existing column starts edit mode. Click the Tab key to move to the next column and set the column's data type.

Altering the table by adding indexes or other features is also possible using the table editor by clicking each tab within the table editor.

PREV HOME UP NEXT