This option enables you to rename multiple columns and is similar to the rename multiple tables wizard.
To rename multiple columns:
- Right-click on a model (or group/schema) and choose Attributes>Rename multiple attributes.
- This can also be done from the Rename multiple entities button in the diagram tool bar. The split button displays the Rename multiple tables and the Rename multiple columns wizard.
- The table name criteria and refine tables list panes of the wizard are identical to the first two panes of the rename multiple tables wizard and allow selecting the tables to be included.
- The Rename columns - Refine tables list dialog enables you to include or exclude tables.
- The Rename columns - Column name criteria dialog enables you to include or exclude column names based on their name in the same way as the 'Entity name criteria' pane.
Icons
Description
Click to Add a filter.
Click to Edit the selected filter.
Click to Delete the selected filter.
- Click Next to display the Rename columns - Column rename criteria pane.
Icons
Description
Click to Add a criteria.
Click to Edit the selected criteria.
Click to Delete the selected criteria.
Click to move the selected criteria a level Up.
Click to move the selected criteria a level Down.
- The available criteria is the same as in the rename tables wizard.
- After adding some criteria, clicking Derive determines which columns will be renamed and what their new name will be.
- If any name conflicts are found, the next pane enables you to adjust the derived names to resolve them.
- Finally, the columns that will be renamed are shown with what they will be renamed to. If you don't want some of these columns to be renamed, deselect the corresponding check-box in the Rename column. Clicking Rename applies the selected renames.
