Default language.

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:

Note

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.

Important

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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*