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

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

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

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.