首页 > 其他 > 详细

PowerDesigner列名作为注释

时间:2015-01-29 23:54:23      阅读:397      评论:0      收藏:0      [点我收藏+]

Tools -> Execute Commands -> Edit/Run Script

执行以下脚本:

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

 

PowerDesigner列名作为注释

原文:http://www.cnblogs.com/cnhxz/p/4261236.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!