How to edit a field in a model

The properties of a field in an open model can be reviewed and edited. Changes affect the field as it occurs only in the project. Columns in the database table remain unchanged.

To edit a field

1. On the SQL tab, expand Tables.
   
   
2. Double-click the table containing the field to be edited.
   
   
3. In the Table\New Table dialog box, select the field by clicking in the gray column to the left of the field name.
   
   
4. Review and edit the properties of the field.

   Changes can also be made on the Basic and Advanced tabs.

5. When all of the desired changes have been made, click OK.

See Also

Advanced Tab (Table/New Table Dialog Box)

Basic Tab (Table/New Table Dialog Box)

Model Editor

SQL Tab (Model Editor)

Table/New Table Dialog Box