Try OpenEdge Now
skip to main content
Basic Database Tools
Field Tasks : Modifying a field
 

Modifying a field

When you edit a field definition, you modify the database's schema. Changing a field's data type from INTEGER to INT64 is a special case (for information, see Changing a field data type from integer to INT64).
To modify a field definition:
1. Choose Schema > Field Editor. The Data Dictionary's Field Editor alphabetically lists all the tables defined for your database.
2. Select the table that contains the field you want to modify. The Field Editor lists all the fields defined for the selected table.
3. Choose Modify.
4. Choose the field you want to modify. The Field Editor displays the field definition in the window. See Field Editor option for information about the fields in this window.
5. Edit the field definition.
6. Press RETURN or GO.
7. Choose Exit to apply the change. An alert box appears, asking if you want to apply or undo the changes to the database, or if you want to make other changes.
8. Choose Apply Changes. The main menu of the Data Dictionary reappears.