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

9.6 Table Templates

Define table templates with commonly used columns and settings to create new tables from either a live connection or while creating an EER model.

From the SQL editor, select Create Table Like from the Tables context menu, as shown in the next figure.

Figure 9.64 New Table Template: SQL Editor

Content is described in the surrounding text.

Or while modeling, click the "Open the table template editor" icon under Modeling Additions, as the following figure shows.

Figure 9.65 New Table Template: Modeling

Content is described in the surrounding text.

After opening the Table Templates manager, make the adjustments and then click Apply to commit the changes. The following figure shows an example of column, data type, and default values that you can adjust for the user template.

Figure 9.66 Table Templates Manager

Content is described in the surrounding text.

To open an existing template from the SQL editor, hover over the Create Table Like context menu and select the desired table template. For modeling, double-click on a template in the right modeling sidebar.