使用PD（PowerDesigner）图如何快速生成创建数据库表的SQL脚本并生成表在数据库

柔光的暖阳◎ 2022-08-29 13:49 334阅读 0赞

> **PowerDesigner版本：16.5**

*  依据自己目前的模块状况参考以下三篇文章进行匹配。

> [根据PowerDesigner的模型生成数据库表][PowerDesigner]
> 
> [powerdesigner如何生成数据库表][powerdesigner]
> 
> [使用PD（PowerDesigner）图如何快速生成创建数据库表的SQL脚本][PD_PowerDesigner_SQL]

*  我的直接是建的PDM模型。因此就省去了以下步骤：**也就是概念模型转换为物理模型**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70][]

### 以上都准备好之后进行以下步骤： ###

--------------------

1.  **转换为PDM或者直接是PDM形势时进行以下步骤：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 1][]

**    2.出现以下界面：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 2][]

**3.按以下图示进行：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 3][]

** 4.继续以下步骤：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 5][]

**5.然后点击确定之后便可保存到对应模型SQL。**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 6][]

**    6.我是因为已经保存了一次，所以会出现以上提示。点击“是”之后出现以下界面**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 7][]

**   7.点击“run”便会直接将生成SQL以表的形势创建在对应数据库中**

![20210803154022504.gif][]

![20210626100647986.gif][]

[五年从程序员到架构师！这是我见过史上最好的程序员职业规划][Link 1]

### [(下一篇) ][Link 2][16 条 yyds 的代码规范][16 _ yyds] ###

### [40 个 SpringBoot 常用注解][40 _ SpringBoot] ###

[别慌，在Java面试的时候，面试官会这样问关于框架的问题？][Java]

# PD专栏推荐 #

**[使用PD（PowerDesigner）图如何快速生成创建数据库表的SQL脚本并生成表在数据库][PD_PowerDesigner_SQL 1]**

[(PD)Powerdesigner在连接线上不显示关系名称][PD_Powerdesigner]

[(PD)PowerDesigner如何将一个包里的表拷贝到另一个表以后在视图中也可以显示？][PD_PowerDesigner]

[(PD)PowerDesigner设计表时显示注释列Comment，Columns中没有Comment的解决办法(关联MySQL)][PD_PowerDesigner_Comment_Columns_Comment_MySQL]

[PowerDesigner常用快捷键助你工作时迅速减半][PowerDesigner 1]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 8][]

**想要实时关注更多干货好文，扫描下图或微信输入【**万言尽书上**】关注：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 9][]

[PowerDesigner]: https://blog.csdn.net/future_1024/article/details/78151034
[powerdesigner]: https://blog.csdn.net/qq_27194467/article/details/75244661
[PD_PowerDesigner_SQL]: https://blog.csdn.net/weixin_30799995/article/details/97995943?utm_medium=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromMachineLearnPai2~default-3.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2~default~BlogCommendFromMachineLearnPai2~default-3.control
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70]: /images/20220829/b32de5b49ace4c0bb7ba72049a1ba5ce.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 1]: /images/20220829/d7884a1bdf6b4528a05244cbbca9e2e0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 2]: /images/20220829/23ab228b5a4546029bcf250343ccd0fc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 3]: /images/20220829/7fe16085954f48bb8ee155ab756329b6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 4]: /images/20220829/c633abb0f98b417b8bc10475afeb261d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 5]: /images/20220829/736357bf02d04f7fbd5c775cf1f5d160.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 6]: /images/20220829/c095e9a84ba94577a49d0c20c023254b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 7]: /images/20220829/ef46b3a60a1446aea4b0f0d23ed7749c.png
[20210803154022504.gif]: /images/20220829/06331d1c1dc04587aea11867dbe9734a.png
[20210626100647986.gif]: /images/20220829/2e5328bf4d794aef888a3da9fd2a3392.png
[Link 1]: https://blog.csdn.net/qq_41570658/article/details/119028483
[Link 2]: https://blog.csdn.net/qq_41570658/article/details/119147877
[16 _ yyds]: https://blog.csdn.net/qq_41570658/article/details/119146661
[40 _ SpringBoot]: https://blog.csdn.net/qq_41570658/article/details/119147814
[Java]: https://blog.csdn.net/qq_41570658/article/details/119171456
[PD_PowerDesigner_SQL 1]: https://blog.csdn.net/qq_41570658/article/details/118933570
[PD_Powerdesigner]: https://blog.csdn.net/qq_41570658/article/details/118808063
[PD_PowerDesigner]: https://blog.csdn.net/qq_41570658/article/details/118763905
[PD_PowerDesigner_Comment_Columns_Comment_MySQL]: https://blog.csdn.net/qq_41570658/article/details/118763769
[PowerDesigner 1]: https://blog.csdn.net/qq_41570658/article/details/118759703
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 8]: /images/20220829/1fb107f0065b4dca875522c33396b3a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 9]: /images/20220829/e7b45625e8cd4c0cb1fab4b531b943af.png