How to edit a table

Sometimes it is necessary to review or edit the fields that are part of a model.

Note Changes affect only the table as it is defined in the model, not its structure in the database.

To modify a table

On the SQL tab, expand Tables and then double-click the table to modify.
Modify the table by adding a field, deleting field, or changing the properties of a field
On the Basic tab, select, enter, or change the options.
Note The available options vary with the Data Type chosen.
Click the Advanced tab and set or change the options related to Null values, denormalization, and aggregation.
If it is necessary to delete a field, click the far left gray column to select the field, and then press DELETE.