1. Attach the value of the name field to the comment comment
The first step: the program to be executed
'******************************** **********************************************'* File: name2comment.vbs'* Title: Name to Comment Conversion'* Model: Physical Data Model'* Objects: Table, Column, View'* Author: steveguoshao'* Created: 2013-11-29'* Mod By:'* Modified: '* Version: 1.0'* Memo: Modify from name2code.vbs'*************************************** *******************************************Option Explicit ValidationMode = True InteractiveMode = im_BatchDim 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 N ext end sub
The second step is to execute the code on powerdesigner
Copy the above code inside, and then execute run;
2, generate sql
Change the sql statement inside Just copy it out and execute it.