Generating application schema metadata triggers

To generate triggers using the metadata you defined, use the Trigger Management form, specifying the tables where you changed metadata.

Insert and Update triggers on the tables are generated by the Trigger Management form. However, not all triggers on all tables are generated by this form. For example, if Iup and Del triggers are required for a table, they are loaded when the application is installed.

Insert and Update triggers require generation after you perform these actions:

  • Add columns to standard tables.
  • Add custom tables, if you want standard trigger functionality.
  • Impact the schema for User Extended Tables with the UET Impact Schema form. (This generates triggers automatically and creates views for multi-site tables.)
  • Upgrade databases where the schema has changed. (This generates triggers automatically.)
  • Run the Database Migration utility. (This generates triggers automatically.)