You must recompile procedures that reference a database table in which you have made any of the following changes:

• Deleted the table
• Changed the table name
• Changed the database language or authorization key
• Added or deleted a field in the table
• Changed the name or order of a field

In addition to the schema changes listed above, you must recompile procedures that reference a database table in which you have made the following changes to a field:

• The data type or extent (array size)
• The number of decimals
• The case sensitivity

Although you do not have to recompile procedures when you make other schema changes, such changes do not apply to procedures that you do not recompile. For example, changes to the following features appear only when you recompile:

• Field appearance — Format, label, column label, and decimal
• Data entry — Initial value, mandatory value, case sensitivity, validation expression, delete validation, and security
• User information — Help messages, validation messages, and description