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

1. On the SQL tab, expand Tables and then double-click the table to modify.
   
   
2. Modify the table by adding a field, deleting field, or changing the properties of a field
   
   
3. On the Basic tab, select, enter, or change the options.

   Note  The available options vary with the Data Type chosen.

4. 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.

See Also

Advanced Tab (Table/New Table Dialog Box)

Basic Tab (Table/New Table Dialog Box)

How to add a field to a table

How to change the table options for a relationship

Model Editor

Table/New Table Dialog Box