PowerDesigner根据SQL生成物理模型

1整理建表SQL语句到test.sql文件；
2打开PowerDesigner->文件目录->Reverse Engineer->Database->General OBMS:选择MYSQL5.0->确定->Selection 选中Using script files 选择test.sql->确定；
3执行完步骤二后模型已经显示出来；
4如果想要name显示的是注释内容，则继续执行一下操作
5工具标签-Execute Commands->Edit/Run Script
copy以下脚本，点击Run按钮，再次查看，发现name已经变成注释内容：

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 
if len(tab.comment) <> 0 then 
tab.name = tab.comment 
end if 
On Error Resume Next 
Dim col 'running column 
for each col in tab.columns 
if len(col.comment) <>0 then 
col.name =col.comment 
end if 
On Error Resume Next 
next 
end if 
next 
end sub