Database Checks (PDM)

PowerDesigner provides default model checks to verify the validity of databases.

Check	Description and Correction
Database name and code uniqueness	Database names and codes must be unique in the model. Manual correction: Modify the duplicate name/code Automatic correction: Appends a number to the duplicate name/code
Database code maximum length	The code of the database is longer than the maximum allowed by the DBMS. Manual correction: Reduce the length of the code Automatic correction: Reduces the code to a permissible length
Database not used	The database you have created is not used in the model. Manual correction: Delete the database or apply the database as a physical option to a table, an index, a key, a column, a storage, a tablespace or a view (Options tab of the object property sheet) Automatic correction: None

Check

Description and Correction

Database name and code uniqueness

Database names and codes must be unique in the model.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Database code maximum length

The code of the database is longer than the maximum allowed by the DBMS.

Manual correction: Reduce the length of the code

Automatic correction: Reduces the code to a permissible length

Database not used

The database you have created is not used in the model.

Manual correction: Delete the database or apply the database as a physical option to a table, an index, a key, a column, a storage, a tablespace or a view (Options tab of the object property sheet)

Automatic correction: None