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 |