PowerDesigner中使用name生成comment

PowerDesigner中使用name生成comment"/>

PowerDesigner中使用name生成comment

PowerDesigner生成数据库脚本时，code转换为数据库中表名及字段，如果将将PDM中的name（一般为中文名称）转换为comment，则生成数据库备注栏显示name（中文名称），方便程序员的使用。将name转化为comment，可使用以下脚本批量完成。

Option Explicit  
ValidationMode = True  
InteractiveMode = im_Batch  Dim mdl 'the current model  'get the current active model  
Set mdl = ActiveModel  
If (mdl Is Nothing) Then  
MsgBox "There is no current Model"  
ElseIf Not mdl.IsKindOf(PdPDM.cls_Model) Then  
MsgBox "The current model is not an Physical Data model."  
Else  
ProcessFolder mdl  
End If  'This routine copy name into code for each table, each column and each view  
'of the current folder  
Private sub ProcessFolder(folder)  
Dim Tab 'running table  
for each Tab in folder.tables  
if not tab.isShortcut then  
tabment = tab.name  
Dim col 'running column  
for each col in tab.columns  
colment= col.name  
next  
end if  
next  Dim view 'running view  
for each view in folder.Views  
if not view.isShortcut then  
viewment = view.name  
end if  
next  'go into the sub-packages  
Dim f 'running folder  
For Each f In folder.Packages  
if not f.IsShortcut then  
ProcessFolder f  
end if  
Next  
end sub 

上述代码来源与网络，出处不详
点击菜单栏Tools – Execute Commands – Run Script

将上述代码粘贴至下图运行即可完成

使用时特别注意：上述代码将使用Name替换原有comment，原有的comment内容将会被覆盖