Structural Changes

If you make a structural change to your database, you may need to reorganise the database. Any of the following changes are structural:

• Adding an index link to your database

• Enabling an index on a table that contains data

In both these cases you will have to build this index using the Reorgansise an Index option before you can access data using the new index. If you make any of the changes below to tables containing data, you will have to completely rebuild the database index:

• Modifying a key field in a table in the following ways:

  • changing the key precedence,
  • changing the data type
  • changing the number of occurrences

  • changing the scale factor

• Adding an extra key field to a table

• Deleting a key field in a table

If you make any of these changes, DP4 forces you to reorganise the database structure. Follow the instructions in Reorganising the Database to run the Database Reorganisation utility.