(问题1).导入sql文件形成模板
解决方案:
1.1选着Database
1.2设置模板名 点击确定
1.3 选着sql文件执行
(问题2).PowerDesigner默认修改Name时候Code会跟随 如下图
解决办法:
路径:Tools —> Genneral Options 选着Dialog菜单 取消勾选Name to Code mirroring
(问题2).PowerDesigner用sql文件生成Table时默认Name与Code为数据库表字段名 如下图
解决办法:
Tools —> Genneral Options 选着Dialog菜单 取消勾选Name to Code mirroring
(问题3).PowerDesigner用sql文件生成模板Table时Name不是注释
解决办法:
1.先导入文件生成Table 然后执行下面脚本
2.执行脚本
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
3.自动替换Name