Schema Templates

Schema templates allow you to load pre-existing field and index definitions into the table designer. If many of your tables include similar base schema structures, this is an easy way to quickly create new tables from existing templates.

Schema templates provide the following functionality:

•	Create a new schema template from scratch

•	Create a new schema template from an existing table structure

•	Create a new schema template from an existing schema template

•	Create a new table from an existing schema template

Creating a New Schema Template

Schema templates can be created using the Table Designer.

1.	Open the Table Designer (Control+N, or right-click the Tables node and click Create).

2.	Specify your schema by adding fields and indexes.

3.	Select Save As from the Schema menu.

Creating a New Schema Template from an Existing Table

Schema templates can be created using definitions from an existing table.

1.	From the table you would like your template to be based on, open the table properties (right-click the table and select Properties from the quick menu).

2.	Either save the schema template via the Schema menu, or edit the current properties and save the schema when you are done making changes.

Creating a New Schema Template from an Existing Template

Schema templates can be created using an existing template as a starting point.

1.	Open the Table Designer (Control+N, or right-click the Tables node and click Create).

2.	Select Load from the Schema menu and chose a template file to use as a starting point.

3.	Modifying the existing schema.

4.	Select Save As from the Schema menu to save the new schema template.

Creating a New Table from an Existing Schema Template

Tables can be created using an existing schema template.

1.	Open the Table Designer (Control+N, or right click the Tables node and click Create).

2.	Select Load from the Schema menu and chose a template file to load.

3.	Make any changes or additions.

4.	Click OK to create the new table.