To rename multiple entities within a model version...
Right-click on the version of the model in the left pane and select Entities>Rename multiple entities. Alternatively, right-click on a white space in the diagram and select Tables>Rename tables or click on REPLACE WITH THIS IMAGE: Images/Common_Icons/table_rename.png in the toolbar and select Rename multiple tables from the list.
REPLACE WITH THIS IMAGE: Images/Wizards/Renaming Multiple Entities.png
- Click REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png to specify which tables are to be included or click REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png to specify which tables are to be excluded in this renaming process. Click Next.
REPLACE WITH THIS IMAGE: Images/Wizards/Renaming Multiples Entities in a Group_1.png
- The tables matching the criteria in the last step are displayed. Move any specific tables not to be included to the Exclude tables list and click on Next.
REPLACE WITH THIS IMAGE: Images/Wizards/Renaming Multiples Entities in a Group_2.png
- From Table rename criteria, manage the rename criteria, click REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png to add a rename criteria.
REPLACE WITH THIS IMAGE: Images/Wizards/Renaming Multiples Entities in a Group_3.png
Icons | Description |
---|---|
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png | Click to Add rename criteria. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png | Click to Edit the selected criteria. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png | Click to Delete the selected criteria. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/down.png | Click to move the selected criteria a level Up. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/up.png | Click to move the selected criteria a level Down. |
- Select a Criteria from the drop down list and enter one or two values where appropriate.
REPLACE WITH THIS IMAGE: Images/Wizards/Renaming Multiple Entities_4.png
The options are as follows:
Options | Descriptions |
---|---|
Replace any x with y | Replace any Value 1 with Value 2. |
To lower case | Convert to lower case. |
To upper case | Convert to upper case. |
Add before | Add Value 1 before the name. |
Add after | Add Value 1 after the name. |
Remove first N characters | Remove the first (Value 1) characters, where Value 1 is an integer. |
Remove last N characters | Remove the last (Value 1) characters, where Value 1 is an integer. |
Remove before and including | Remove the characters in the name before and including Value 1. |
Remove after and including | Remove the characters in the name after and including Value 1. |
Remove everything before first upper case | Remove everything in the name before the first upper case letter. |
Remove everything from last upper case | Remove everything in the name from the last upper case letter onwards. |
- Select the required criteria and click Derive.
REPLACE WITH THIS IMAGE: Images/Wizards/Renaming Multiples Entities in a Group_4.png
- With only the required tables selected, click Rename.
REPLACE WITH THIS IMAGE: Images/Wizards/Renaming Multiples Entities in a Group_5.png