PowerDesigner显示Comment注释

Name是名称（字段描述），Code是字段名称，Comment是字段注释，ER图中显示的是Name。一般设计时，Name跟comment都设计成用于描述，常把comment写成中文，name保留跟code一致，保存完毕后，可以把comment替换到name上。当然也可以用name替换comment。具体方法如下：

• 通过执行VBS脚本，用Commen覆盖Name：

  Option   Explicit   
      ValidationMode   =   True   
      InteractiveMode   =   im_Batch
      Dim blankStr
      blankStr   =   Space(1)
      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  
        
      Private   sub   ProcessFolder(folder)   
      On Error Resume Next  
            Dim   Tab   'running     table   
            for   each   Tab   in   folder.tables   
                  if   not   tab.isShortcut   then   
                        tab.name   =   tab.comment  
                        Dim   col   '   running   column   
                        for   each   col   in   tab.columns   
                        if col.comment = "" or replace(col.comment," ", "")="" Then
                              col.name = blankStr
                              blankStr = blankStr & Space(1)
                        else  
                              col.name = col.comment   
                        end if  
                        next   
                  end   if   
            next  
        
            Dim   view   'running   view   
            for   each   view   in   folder.Views   
                  if   not   view.isShortcut   then   
                        view.name   =   view.comment   
                  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
  

• 通过执行VBS脚本，用name覆盖comment：

  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 
                          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
  

打开菜单Tools>Execute Commands>Edit/Run Script… 或者用快捷键 Ctrl+Shift+X