Tips for using powerdesigner

-> Generate database. In the pop-up database generation dialog box, select the script access path and script file name.
3. Click "OK" to generate a database creation script (*. SQL)

Ii. An error occurred while generating the Script: column code maxinum lenght
Cause: an error occurs when the field exceeds 15 characters (Oracle)
Solution: Open PDM, database-edit current DBMS-script-objects-column-maxlen, and increase the value (Originally 30), for example, to 60. If the length of a table or other objects is incorrect, you can select the corresponding objects and change it accordingly!
Or use the following method: the database generation prompt box will pop up when the table creation script is generated: remove the options-check model, that is, do not check.

3. Remove the default new table name and field name with double quotation marks.
Open Database-> edit current DBMS, and an editing interface appears. In the box on the right, locate the Script node, and then find the SQL-> Format node in sequence, the following is an attribute of this name: casesensitivityusingquote, set the value of this attribute to "no", and then read the generated script, all double quotation marks are removed.

In fact, with double quotation marks, SQL should also be able to pass, and with double quotation marks, the generated table name \ column name will strictly follow the case we set, without double quotation marks, in Oracle, it is converted to uppercase.

 

4. Use name to replace the empty comment: Generate name in empty comment when generating the script
Database-> database generation-> options-> Generate name in empty comment
If no comment is written during design, replace it with name.

 

5. When the field name of the table is modified, the Code does not automatically change.
Tools-> General options-> dialog: operation modes: nametocodeconfiguring (checked = false)

 

6. Show the comment option when editing the table
In PD, comment is not displayed by default when you edit a table. If you want to display:

Right-click the table you want to edit, and choose Properties> Columns> customize columns and filter (or press Ctrl + U directly)-> comment (check previously)-> OK.

 

7. Set entity to automatically adjust the size
When a field or other modification is added to the entity, the display size of the entiry is not adjusted automatically. If you want to adjust it automatically, right-click the entity → click format... Menu item → select the size tab → select Auto adjust to text

 

8. Set the default font of Entity
When you create an entity object, if the default PD font is not suitable for your personal habits, it is very troublesome to modify the font of the object every time you create an object, is there a way to change once and for all? Tools → display preferences... → Format → entity → modity... → Font → modify and Save settings → set as default

 

9. The erimage generated in PDM is too small to be clearly visible

When there are too many tables and relationships in a graph, the default report graph cannot be clearly displayed. You need to set it.

Report --> Report Templates --> select the report template you want to generate, for example, standard Phsical report --> select and select the first button (edit button) in the upper left corner) ---> In the window on the right, right-click graphics --> Format ---> select Custom to adjust the percentage ---> OK

 

 

10. Convert the name and code of the table columns to lowercase letters.

Tools --> model options --> name convertion --> column --> code --> lowercase ---> set as defalut ---> OK

-> Generate database. In the pop-up database generation dialog box, select the script access path and script file name.
3. Click "OK" to generate a database creation script (*. SQL)

Ii. An error occurred while generating the Script: column code maxinum lenght
Cause: an error occurs when the field exceeds 15 characters (Oracle)
Solution: Open PDM, database-edit current DBMS-script-objects-column-maxlen, and increase the value (Originally 30), for example, to 60. If the length of a table or other objects is incorrect, you can select the corresponding objects and change it accordingly!
Or use the following method: the database generation prompt box will pop up when the table creation script is generated: remove the options-check model, that is, do not check.

3. Remove the default new table name and field name with double quotation marks.
Open Database-> edit current DBMS, and an editing interface appears. In the box on the right, locate the Script node, and then find the SQL-> Format node in sequence, the following is an attribute of this name: casesensitivityusingquote, set the value of this attribute to "no", and then read the generated script, all double quotation marks are removed.

In fact, with double quotation marks, SQL should also be able to pass, and with double quotation marks, the generated table name \ column name will strictly follow the case we set, without double quotation marks, in Oracle, it is converted to uppercase.

 

4. Use name to replace the empty comment: Generate name in empty comment when generating the script
Database-> database generation-> options-> Generate name in empty comment
If no comment is written during design, replace it with name.

 

5. When the field name of the table is modified, the Code does not automatically change.
Tools-> General options-> dialog: operation modes: nametocodeconfiguring (checked = false)

 

6. Show the comment option when editing the table
In PD, comment is not displayed by default when you edit a table. If you want to display:

Right-click the table you want to edit, and choose Properties> Columns> customize columns and filter (or press Ctrl + U directly)-> comment (check previously)-> OK.

 

7. Set entity to automatically adjust the size
When a field or other modification is added to the entity, the display size of the entiry is not adjusted automatically. If you want to adjust it automatically, right-click the entity → click format... Menu item → select the size tab → select Auto adjust to text

 

8. Set the default font of Entity
When you create an entity object, if the default PD font is not suitable for your personal habits, it is very troublesome to modify the font of the object every time you create an object, is there a way to change once and for all? Tools → display preferences... → Format → entity → modity... → Font → modify and Save settings → set as default

 

9. The erimage generated in PDM is too small to be clearly visible

When there are too many tables and relationships in a graph, the default report graph cannot be clearly displayed. You need to set it.

Report --> Report Templates --> select the report template you want to generate, for example, standard Phsical report --> select and select the first button (edit button) in the upper left corner) ---> In the window on the right, right-click graphics --> Format ---> select Custom to adjust the percentage ---> OK

 

 

10. Convert the name and code of the table columns to lowercase letters.

Tools --> model options --> name convertion --> column --> code --> lowercase ---> set as defalut ---> OK