DATA - Data Governance > Data Architecture and Tools > Modeling Databases > Database Components > Table Columns
Table Columns
Viewing columns
See previously: Database Properties.
To view the columns of a table:
1. Open the table properties window.
2. Click the Columns page.
Presented for each column are:
• Its Local Name
• Its Datatype
*The administrator can add to the list of datatypes (see Creating New Datatypes).
• Its length Ln and its number of decimals Dcml where appropriate.
• The value of its NotNull attribute.
• Its default value: on generation of the table, the default value taken is that of the attribute from which it originated. If no initial value is specified for the attribute, or if you want to modify the value of a column, enter a value in this field.
• The fact that the column is connected or not connected to a primary key (PK) or foreign key (FK). This is indicated by Y ("Yes") or N ("No").
You can modify the Local Name for a column by clicking its name and then entering the new name. This local name will be used in the script generated for the table.
An SQL Name can be specified directly in the SQL page of the properties of an attribute in the data diagram. Then all columns created from this attribute will have the same local name. In addition, the name will be reused during successive synchronizations, including total or partial reinitializations.
It is also possible to modify the value of other column characteristics.
*These modifications will be retained in subsequent synchronizations.
It is possible to create columns not derived from attributes in the data diagram whether in a table generated or created by the user.
Creating a column
See previously: Database Properties.
To create a column:
1. Open the properties of the table concerned.
2. In the Columns page, click New.
*When creation of a column is not carried out from the Properties of a table, but for example from the explorer, it is necessary to previously select the table that will contain it, otherwise a message will indicate that creation is impossible.
Deleting a column
To delete a column:
1. Right-click the column and select Remove.
A message requests confirmation of the final deletion.
2. Click Delete.
*The deleted column will not be automatically recreated at a new synchronization. To recreate a column, at the synchronization results validation step validate the creation action proposed for this column (select the corresponding check box). See Step 4: Validating results.
The Reorder button accesses the Modify Order dialog box.