PowerDesigner provides default model checks to verify the validity of indexes and view indexes.
Check |
Description and Correction |
---|---|
Name/Code contains terms not in glossary |
[if glossary enabled] Names and codes must contain only approved terms drawn from the glossary.
|
Name/Code contains synonyms of glossary terms |
[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
|
Name/Code uniqueness |
Object names must be unique in the namespace.
|
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.
|
Existence of index column |
An index must have at least one index column.
|
Undefined index type |
[indexes] An index type must be specified.
|
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.
|
Uniqueness forbidden for HNG index type |
[indexes] An index of HNG (HighNonGroup) type cannot be unique.
|
Index inclusion |
An index should not include another index.
|