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 Function Based Indexes Instructions

 

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

Rename Function Based Indexes Instructions

 

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

Rename Function Based Indexes Instructions