To modify a user-defined table

Warning!  

Take a snapshot of your database with customizations. All customized objects (triggers, additional indexes, special permissions) are lost when user-defined tables are rebuilt.
If you created a process automation task with an On database change trigger on a user-defined table, be sure to disable that task before making any changes to the user-defiend table. From the Staff site, go to RiSE > Process automation, select the task, edit the trigger, and deselect Enabled. Save the changes. After you Create/Update Server Table in iMIS Desktop, go to RiSE and enable the trigger.

1. Make sure all other users exit the iMIS system.
2. Back up your data.
3. Log on as the database owner: MANAGER.
4. From Customers, select Set up module > General, and click Additional Windows to open the Customer Setup – Additional Windows window.
5. Click Define Tables to open the User Defined Tables window.
6. Select the Table Name drop-down list, and select the table you want to modify.
7. Make the necessary changes:
• To add a field to the table, place the cursor anywhere in the field row where you want the new field to follow, and click Insert Line on the User Defined Tables window. A new field row is inserted, and the new field information can be added here.
• To delete a field on the table, place the cursor anywhere in the field, and click Delete Line on the User Defined Tables window.
• To reorder the fields, select the field, and click Up or Down on the User Defined Tables window.
8. Click Save. iMIS prompts you to update the server table.
9. Click Yes.
10. Click OK if prompted to restart iMIS.
11. Click Auto-Create Window.
12. Click Close to close the User Defined Tables window.
13. From Tools > Utilities, select User defined tables. Click Build All to generate business objects from user defined tables.
14. Exit iMIS immediately.
15. (content items using UD tables) Restart IIS so any new field added to a user defined table is included as available fields in existing content items.