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: