PowerDesigner displays comment comments

PowerDesigner The default displayed column is Name And type , As shown in the figure below ：

Now you need to display the comment column , In order to make ER The picture is clearer . however PowerDesigner Check Comment The display has no effect , So deal with it through the following steps ：

Double click on the table , The table properties dialog box pops up , Cut to Columns, The default is not displayed Comment Of , Show Comment Column , The operation is as follows ：

Sure to save , open a menu Tools>Display Perferences

Check name, adjustment code

  after , as follows

open a menu Tools>Execute Commands>Edit/Run Script.. Or use the shortcut key Ctrl+Shift+X, Execute the following code ：

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

  after , as follows ：

  The principle is to display name The value of the column , Replace with the value of the comment , So next time if you adjust comment, And re execute the script , So it's best to put it at the end .

Switch database type

The solution to the problem that the database table script contains double quotation marks

stay PowerDesigner Medium Database -> Edit Currnet DBMS -> Script -> Sql -> Format -> CaseSensitivityUsingQuote Choose from No, that will do ：