1. Download powerDesigner
The link address is http://soft.onlinedown.net/soft/577763.htm
2. Open the software, file -> new project, create a new project; then create a new entity to build a table;
3. Right-click entity -> new directly, and the corresponding pop-up box will appear, as shown in the figure:
< img alt="Share a picture" src="/wp-content/uploads/images/database/power-designer/1626816353032.png" width="563" height="385" >
You can create the corresponding table name and column attributes, just confirm it, Note:
The self-increasing column can click on this row, and it will appear In the pop-up box, check this, as shown in the figure:
It is worth noting that directly saves and generates a .cdm file, The built physical model will generate a .pdm file, the method of generating a pdm file:
Select this.
4. Open the .pdm file, you will find that the menu bar has an extra database item:
Click database -> generate database, select the table to export sql, and click OK.
p>
How about, is it very simple~~~