Define the structure of a new table

A Table Template defines the structure and format for new tables you create in the database. The Table Template is stored in the SQL.DEF file.

Create a new Table Template

1. In the Tools pane, expand SQL Access Manager, and select Table Template.

2. Select New.

   The Table Template Configuration dialog box appears.

   

3. In the Table Template Name box, type the name of the Table Template.

   A Table Template name can be up to 32 characters without an index. If you are creating an index, unique or otherwise, the Table Template name must not exceed 24 characters.

4. In the Column Name box, type the column name of the Table Template.

   A column name can be up to 30 characters.

5. In the Column Type box, type the data type for the column. Data type selections vary according to the database being used.

6. In the Index Type area, select one of the following options:

   • Unique: Each column value must be unique.

   • Non-Unique: Each column value is not required to be unique.

   • None: No index.

     Note: When you run a script containing the SQLCreateTable() function, an index file is automatically created.

7. Select Allow Null Entry to allow null data to be entered in this column.

   Note: InTouch does not support null data.

   When inserting data, if a value has not been entered for a tag, null values are assigned by the type of tag.

   Data Type	Value
   Discrete	0
   Integer	0
   Message	Strings with no characters

8. Select Add Item to add your new column name, column type, length, and index type to the Table Template.

9. Select OK to save your new Table Template configuration and close the dialog box.

Modify a Table Template

10. In the Tools pane, expand SQL Access Manager, and select Table Template.

    The Select a Table Template dialog box appears.

11. Select the Table Template name that you want to modify, and then select Modify.

    The Table Template Configuration dialog box appears.

12. Modify the required item.

13. Select OK to save your changes and close the dialog box.

Delete a Table Template

14. In the Tools pane, expand SQL Access Manager, and select Table Template.

    The Select a Table Template dialog box appears.

15. Select the Table Template name that you want to delete.

16. Select Delete. A message appears requesting confirmation to delete the Table Template.

17. Select Yes. The Table Template Configuration dialog box reappears.

18. Select OK to close the dialog box.