(Glue-2305) Modify SNP Glue™ Table
There are two possible ways how you can modify an existing table:
- Click Change on the initial screen of the SNP Glue™ Dictionary
- Click Edit <-> Display in the display mode of a table
Inactive table
By editing an inactive (saved) table, you can change all available settings (storage, description, field mapping, etc.).
Change active table
By altering an active table the following warning message is displayed:
The technical name of this functionality is alter table. You can append new fields to an active table and change its description.
New fields can only be appended to the end of the already active fields. If the added fields are not positioned at the end of the table (append), they are automatically sorted in the correct way after the table is saved or activated.
You can use also Insert and Delete buttons, but you can modify only the newly created fields.
After you save the changes, the table is in Active (Revised) status while in display mode and in Inactive status while in edit mode. The Activate button alters a table on the selected storage.
The main screen in edit mode for active table
We recommend reactivating the SNP Glue™ metaobjects after the SNP Glue™ table alternation. This step does not influence other SNP Glue™ components.