Column Templates


Certain common columns appear in many tables. Rather than repetitively adding these columns over and over, column templates can be used.

All column templates allow you to specify column name, data type, length, primary key, etc.

Templates will appear in the Add Table dialog box when creating new tables.

There are two basic types of column templates: those with fixed column names and those with generated column names.

Creating and Editing Column Templates

Column templates are created and edited in the Preferences panel, which is accessable from the main Edit menu.


Use the Preferences panel to add, edit and delete column templates. Also use it to move templates up and down in the sort order.

Fixed Column Name Templates

These templates are simpler to use and are used for columns that don't use the name of the table in their own name.


Fixed Name Column Templates

Generated Column Name Templates

These templates are useful for columns with names that contain the name of the table. For example, the Id column may contain the name of the table as a 'base name' with a prefix or suffix of 'Id' appended on.


Column Template with a Generated Name


Use the Advanced tab to specify the prefix and suffix to use in the generated column name.


See also:

Designing A Database
Creating Columns