显示注释列
进入首选项
显示code.png
选择code
image.png
https://blog.csdn.net/qq_17010367/article/details/79212850
自定义列属性.png
显示code列.png
设置完毕后效果如下图:
image.png
在PowerDesigner中,表结构的code,name字段均为英文,不易阅读,若需要将备注中的字段替换到name字段显示,则执行方法:Tools -- Execute Commands -- Edit/Run Script ,则弹出如下图中的对话框:
image.png
image.png
Vb script代码 如下:
OptionExplicitValidationMode=TrueInteractiveMode=im_BatchDimmdl 'the current model 'get the current active modelSetmdl=ActiveModelIf(mdlIsNothing)ThenMsgBox"There is no current Model"ElseIfNotmdl.IsKindOf(PdPDM.cls_Model)ThenMsgBox"The current model is not an Physical Data model."ElseProcessFoldermdlEndIf'Thisroutine copy name into codeforeachtable,eachcolumnandeachview 'of the current folderPrivatesubProcessFolder(folder)DimTab'running tableforeachTabinfolder.tablesifnottab.isShortcuttheniflen(tab.comment)<>0thentab.name=tab.commentendifOnErrorResumeNextDimcol 'running columnforeachcolintab.columnsiflen(col.comment)<>0thencol.name=col.commentendifOnErrorResumeNextnextendifnextendsub
执行后可以将vbscript保存到本地,下次执行时执行本地脚本即可
image.png
执行后的效果如下图:
最终效果图.png
3. PowerDesigner导出SQL时如何添加注释
参考:
https://jingyan.baidu.com/album/47a29f24652e44c0142399c3.html?picindex=2
4. # PowerDesigner生成mysql字段comment 注释
参考:https://www.cnblogs.com/kangxuebin/articles/3688146.html
5. PowerDesigner将PDM导出生成WORD文档