iNTERFACEWARE™ Inc.

Viewing the Table Definition

You can easily view any table contained in the Workspace.

To view a table definition:

• Under Tables, double-click the table you want to view. The Table Definition Window appears for the selected table. In this example the Patient table definition is shown.

Table Definition Window

From this window you can:

• Add, insert or delete fields (using the right-click context menu);
• Change the name of a field;
• Change the data type (using the ellipsis button);
• Specify which field(s) should be used as the Primary Key (The key field only applies to Iguana users. For more information, see Table Properties.);
• Add a description of a specific column name;
• View/add a Python outbound script to modify values immediately after they extracted from the tables (using the ellipsis button); and
• View/add a Python inbound script to modify values just before they are inserted into tables (using the ellipsis button).