powerdesigner 导出sql时会自动添加 type=myisam 如何去掉

发布网友发布时间：2022-04-08 03:42

我来回答

共2个回答

懂视网时间：2022-04-08 08:04

1、使用脚本的方式

技术分享

在里面运行

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   comment   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
                  ‘把表明作为表注释，其实不用这么做
                  tab.comment   =   tab.name
Dim   col   ‘   running   column
for each   col   in   tab.columns
                        ‘把列name和comment合并为comment
                        col.comment=   col.name
next
end if
next

Dim   view   ‘running   view
for each   view   in   folder.Views
if not   view.isShortcut   then
                  view.comment   =   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

点击run后

powerdesign导出SQL时自动生成注释

标签：powerdesigner

热心网友时间：2022-04-08 05:12

在PowerDesigner中点击DataBase -----------> Generate Datebase -----(可以点击Preview预览sql语句)------->设置sql文件的存放路劲以及生成文件的名称 ------------------>点击确定即可。
在导出的时候可能会报 Generation aborted e to errors detected ring the verification of the mod
错误，这时需要在导出页面把把检查模型的选项（Check Model）前的那个勾去掉即可。