首页 > 代码库 > PowerDesigner列名作为注释

PowerDesigner列名作为注释

Tools -> Execute Commands -> Edit/Run Script

执行以下脚本:

Option ExplicitValidationMode   = TrueInteractiveMode   =   im_BatchDim   mdl      the   current   model   get   the   current   active   model Set   mdl   =   ActiveModel If   (mdl   Is Nothing)   ThenMsgBox "There   is   no   current   Model "ElseIf Not   mdl.IsKindOf(PdPDM.cls_Model)   ThenMsgBox "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 nextend ifnextDim   view   running   view for each   view   in   folder.Views if not   view.isShortcut   then                  view.comment   =   view.name end ifnext   go   into   the   sub-packages Dim   f      running   folder For Each   f   In   folder.Packages if not   f.IsShortcut   then                  ProcessFolder   f end ifNextend sub

 

PowerDesigner列名作为注释