The Column Manager allows you to view and modify the basic parameters of all the table columns within the diagram. To open the Column Manager use the Diagram | Column Manager menu item.
The Column Manager consists of the following areas:
The grid rows stand for the diagram columns, and the grid columns for the diagram column parameters. These parameters can be changed by using Column Editor for each table one by one, but with Column Manager you can do it much more quickly.
The grid allows you to modify the following column properties:
The name of the column, which must be unique within the diagram;
The name of the table which owns a column. This property can't be changed;
The data type of the column;
You can specify a column domain, see the Domains topic for detailed information;
Specify this option to include the field into the table primary key;
An arbitrary description for the column.
The Properties pane allows you to define the advanced properties of the column, selected in the Column Grid. Please refer to Column Editor topic to see the meaning of properties.
To save your changes click the OK button. If you want to store changes and continue editing, click on the Apply button.
Searching column in the list
If your diagram contains large number of table columns, it may be important to search for a column in a most easy way. To find a column quickly by its name, click the Find button () at the dialog toolbar. The Find Name dialog will appear. Type in the name of column to find and click OK. If the column is found the grid cursor positions on the appropriate row.
Running the Column Editor
If you want to change some parameters of the column parent (e.g. add or remove columns or indexes), select the appropriate column in the dialog and click the Edit button () of the dialog toolbar. The Column Editor will appear, where you can edit all the parameters for the selected column and for its parent table.