Updating existing SQL tables

You can use the SQL Tables form to update a table that you imported into the application database. These are tables that were not created using the SQL Tables form.

To prepare an existing table for application access:

Open the SQL Tables form.
Specify this information:

Schema

Select a database schema from the list.

Table Name

Select the SQL table from the list.

Note: Your system administrators can use the Metadata Access Controls form to restrict access to core SQL tables. SQL tables that are set to Locked in the Metadata Access Controls form are not available in the list. You can select SQL tables that are set to Read Only but you cannot modify them. You can view and modify SQL tables that are set to Unlocked.
Click Filter In Place.
Click Update Current Table.

Note: If the selected table is set to Read Only in the Metadata Access Controls form, then this button is disabled.

These actions are performed to the table:

Add the standard Mongoose-based application columns such as Create Date and Updated By.
Create the Delete, Insert and UpdatePenultimate triggers.
Add application schema table metadata.