How to customize the name of entity index

The database index helps to improve the performance on data retrieval on the database tables. The index allows database engine locate the required data without having to search in every record in the database table. When defining index for tables in Visual Paradigm, by default the index name will be automatically generated according to a predefined pattern and it is not editable by user.

To customize the index name:

1. Click the … button next to the index name and select Configure Index Name Pattern… from popup menu
   

   Configure Index Name Pattern

2. The Project Options dialog will automatically lookup the index pattern setting for you. In Index Pattern remove any format setting.
   

   Clear index naming pattern

3. Press OK to close the Project Options
4. After that you can freely define the name of your index.
   

   Enter customzied name for your index

Related Know-how

How to create calculated column in ERD Create relationship between entities using unique index How to make 2 entities map to a single class

Related Link

Overview of Database Design & Management with Visual Paradigm Drawing Entity Relationship Diagram (User’s Guide) Generating Object-Relational Mapping Code (User’s Guide)