New field assistant new-field-wizard
An assistant accessible via Tools > Advanced > Add new fields lets you add one or more fields to a table in the database.
Validating the assistant updates the extension schema of the table to be extended and launches the SQL script to modify the physical structure of the database.
This assistant has the advantage of quickly adding a field without needing to know the structure of a data schema.
The main disadvantage is the limitation of the data and the properties to be extended.
The assistant screens contain the following steps:
-
The first page lets you enter the name of the schema to be extended and the namespace of the extension schema where the modifications will be saved:
-
The next page lets you enter the properties of the field to be added.
-
To confirm the changes, click the Finish button.
An extension file, called “cus:recipient” in our example, is automatically created and the corresponding SQL script is executed:
<srcSchema extendedSchema="nms:recipient" label="Recipients" name="recipient" namespace="cus">
<element name="recipient">
<attribute belongsTo="cus:recipient" dataPolicy="email" label="Email" length="80" name="email1" sqlname="sEmail1" type="string" user="true"/>
</element>
</srcSchema>