Rename Function Based Indexes Instructions

This macro iterates all indexes in a model and renames them to EntityName<number>_fb_i.

1. Download and install the package to Toad Data Modeler.

How to import custom packages

2. Click Macros | Rename Indexes

rename-index1.png-320x240

 

The macro changes names of function based indexes (Indexes where option Generate Expression is enabled).

rename-index2

3. To modify the code, open Package Explorer and edit code of the RenameIndexes macro.

rename-index0.png-550x0