Table updates for AR System form changes
When you restructure a regular form by adding, deleting, or changing the length of fields, BMC Remedy AR System restructures the underlying database to reflect those changes.
This section contains information about:
- Table updates when adding fields to a form
- Table updates when deleting fields from a form
- Table updates when changing character field lengths
This section does not apply to join forms. Adding or deleting fields in a join form simply adds or removes the references to the fields in the underlying form. You cannot change the length of a field in a join form because it is defined in the underlying form.
For view forms, the database view is re-created when any fields are added or removed. The database is not re-created if field properties (for example, length) are changed.
Consider performance when you restructure your database. When a table is restructured, the performance impact of the operation depends on the amount of data in the table. If the table contains a large amount of data, the restructuring operation might take a long time, and it might take a large amount of log and data space within the system. Accordingly, plan updates to occur during hours when access to data in the system is not critical.