Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Edit
Editing a Table
To change table details:
- In the ERD, to open a table's properties:
- either click on the
- table header bar
- Or from the more menu select Edit.
- See Table for the options available to edit.
Edit Attributes
- Double-clicking an attribute visible on an ERD or double-clicking on one from within a table's properties attributes section, will open its properties ready for editing.Common Tasks:
- Changing the attribute name, can be achieved by simply updating and saving the Name value. Changing the data type, can be necessary
- or in the table header bar, click
and selectInsert excerpt _more_options_erd _more_options_erd nopanel true
.Insert excerpt _edit _edit nopanel true - PhixFlow opens the table properties; see Table for details about the options.
Editing Attributes
To change attribute details:
- In an ERD, in a table,
- in the table, click an attribute listed in the table
- alternatively, open the table properties. In the Attributes section, double-click on an attribute name.
- PhixFlow opens the attribute properties; see Attribute for details about the options.
Things you might want to edit for an attribute:
- Change the attribute name
Update the Name field and click
.Insert excerpt _finish _finish nopanel true Change the data type
You may need to do this if there is a change in the data or
the wrong type was initially applied.
Click the Type field drop-down and select a type from the list; see Understanding Data Types
.
Note You can only change the data type
for an attribute when it contains no data. If your attribute already contains data, see Clearing and Loading Data in an ERD
.
Adding an expression
: Expressions can be added to attributes to apply processing or populate a value. For example, to uppercase the values in the attribute or setting a fixed string value. See Functions for all available options.