View Checks (PDM)

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

Check

Description and Correction

View name and code uniqueness

View 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

View code maximum length

The view code length is limited by the maximum length specified for the table code length.

Manual correction: Modify the view code length to meet this requirement

Automatic correction: Truncates the view code length to the maximum length specified in the DBMS definition

Existence of permission

Permissions are usage restrictions set on a view for a particular user, group or role.

Manual correction: Define permissions on the view for users, groups and roles

Automatic correction: None