PowerDesigner provides default model checks to verify the validity of indexes.
Check |
Description and Correction |
---|---|
Index name and code uniqueness |
Depending on the DBMS, a model or a table cannot contain two indexes with identical name and/or code. Manual correction: Modify the duplicate name/code Automatic correction: Appends a number to the duplicate name/code |
Index code maximum length |
The index code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the category) or in the naming conventions of the model options.Manual correction: Modify the index code length to meet this requirement Automatic correction: Truncates the index code length to the maximum length specified in the DBMS definition |
Existence of index column |
An index must have at least one index column. Manual correction: Add an index column from the Column tab of the index property sheet or delete the index Automatic correction: Deletes the index without column |
Undefined index type |
An index type must be specified. Manual correction: Specify a type in the index property sheet or delete the index with no type Automatic correction: None |
Index column count |
The current DBMS does not support more than the number of index columns specified in the MaxColIndex entry of the current DBMS. Manual correction: Delete one or more columns in the index property sheet. You can create additional indexes for these columns Automatic correction: None |
Uniqueness forbidden for HNG index type |
An index of HNG (HighNonGroup) type cannot be unique. Manual correction: Change the index type or set the index as non unique Automatic correction: None |
Index inclusion |
An index should not include another index. Manual correction: Delete the index that includes an existing index Automatic correction: None |