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

淡淡的烟草味﹌ 2022-10-04 13:59 679阅读 0赞

1、在所要编辑的表上双击，打开Table Properties窗口，并将上面的选项卡切换到Columns，如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70][]

2、点击Customize Columns and Filter按钮，下图红框中的按钮，或者按Ctrl+U快捷键，如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 1][]

3、在打开的Customize Columns and Filter窗口中，把Comment前面的复选框打上勾，点击OK按钮，如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 2][]

4、这时，就可以在Table Properties窗口Columns选项卡页中看到Comment了，如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 3][]

5、但是，确定保存后回到视图，发现仍没有Comment注释信息，不便我们设计，如下图：

![2019073119561172.png][]

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

6、在工具栏找到*Model->Extensions，如下图：*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 4][]

7、新建一个，然后点击箭头属性按钮，如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 5][]

8、*Profile*右键，点击*Add Metaclasses*，如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 6][]

9、选择*Column*，然后点击OK，如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 7][]

10、选中*Column*，右键选择*New->Extended Attribute，*如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 8][]

11、给Name*一个名字，dataType选择String，选中Computer，选中Read only，如下图：*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 9][]

12、*切换到Get Method Script tab:把原有的代码：*

%Get% = ""

改成：

%Get% = Rtf2Ascii (obj.Comment)

如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 10][]

注意：mysql是改成 %Get% = Rtf2Ascii (obj.Comment) 。

13、确定保存，回到视图界面，在工具栏找到*Tools->Display Preferences，如下图：*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 11][]

14、找到*Table->Advanced，如下图：*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 12][]

15、点击*Columns，点击下图红色图标，如下图：*

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 13][]

16、找到前面所设置的attribute，勾选保存OK，zh\_comment就是刚才设置的Name，如下图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 14][]

17、保存回到视图界面，这是table已经显示Comment了，有利于我们进一步设计，如下图：

![20190731200840792.png][]

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

> 原文地址：[PowerDesigner设计表时显示注释列Comment，Columns中没有Comment的解决办法][PowerDesigner_Comment_Columns_Comment]

![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]**

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

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

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

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

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70][]

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

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70]: /images/20221004/e3ca32bb2afe4cb0809ebf8d40e1a1a7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 1]: /images/20221004/1ce0ca30dbe5400a9dbdf64eaba1bd4d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 2]: /images/20221004/095226ba26954815ab3fcadbc9648127.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 3]: /images/20221004/7e95767bc29047a285bd91be8b64a3f9.png
[2019073119561172.png]: /images/20221004/3bc8a4a32f68454e962779429362d2cc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 4]: /images/20221004/02ca0346ad644ff5b7e62fc8fc8feb3b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 5]: /images/20221004/4ba95619bdb648c89a01eadbba7b3fac.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 6]: /images/20221004/c92224edaf10471388f1bf8b2c081a59.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 7]: /images/20221004/6dfd2e8f316e408184314b001decc8d0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 8]: /images/20221004/8ce2fa5c606447c987ddaf6be3cd9389.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 9]: /images/20221004/3125ec8b805749f3ae7adc9872d7d3d8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 10]: /images/20221004/f12912c5b6d54ff9b1f865038b670aa0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 11]: /images/20221004/e3e098d65e464b3fa80dd3534f5b9c66.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 12]: /images/20221004/521ceb42093f4037bf3b0979462530d5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 13]: /images/20221004/9673abb80121422b9ec91ec7f15c2c60.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lhbmc1NzI2Njg1_size_16_color_FFFFFF_t_70 14]: /images/20221004/71c8d28a955b4eeba12374566ad4390d.png
[20190731200840792.png]: /images/20221004/63523c63df344ba2ab38ee797667a55e.png
[PowerDesigner_Comment_Columns_Comment]: https://blog.csdn.net/yang5726685/article/details/97954431?utm_medium=distribute.pc_relevant.none-task-blog-baidujs_title-0&spm=1001.2101.3001.4242
[20210803154022504.gif]: /images/20221004/62aa25756ece4153911aa512618376ba.png
[20210626100647986.gif]: /images/20221004/9c879b145714444c8ebd7df7c47ca621.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]: 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]: https://blog.csdn.net/qq_41570658/article/details/118759703
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70]: /images/20221004/480154d7310e483f8e2196458f9546e0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 1]: /images/20221004/2054486098c949c98ef91e0fe2144cc5.png