Updating Existing SQL Tables

Use this method to update a table that you imported into the application database (that is, a table that was not created with the SQL Tables form).

To prepare an existing table for application access:

  1. Select the table on the SQL Tables form.
  2. Click Update Current Table.

    These actions are performed on the table:

    • Add the standard Mongoose-based application columns such as Create Date, Updated By, and so on
    • Create the Delete, Insert and Updatepenultimate triggers
    • Add application schema table metadata