(GLUE-1806) Change Glue table
There are two possible ways how you can modify an existing table:
- Press Change on the initial screen of the Glue Dictionary
2. Press Edit <-> Display button in the display mode of the table
Inactive table
If you want to edit an inactive (saved) table, you can change all available settings (storage, description, fields mapping ...).
Change active table
You can edit also an active table. Following warning message is displayed when you do so:
The technical name of this functionality is "alter table". You can append new fields to an active table and change it's description.
You can use also Insert and Delete buttons, but you can manipulate only newly created section of fields.
After you save the changes, the table is in an 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.
Figure: Main screen in edit mode for active table
Altering a table is supported only on the storage type "SM_TRS_MS".
Altering a table is not available for external tables.
The 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 a correct way after the table is saved or activated.