在powerdesigner中按ctrl shift x,然后将下面的脚本粘贴进去,并运行,就可以 将列的name生成到注释comment中去 [vb] view plaincopy option explicit validationmode= true interactivemode=im_batch dim mdl 'thecurrentmodel 'getthecurrentactivemodel
在powerdesigner中按ctrl + shift + x,然后将下面的脚本粘贴进去,并运行,就可以
将列的name生成到注释comment中去
[vb] view plaincopy
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
显示注释操作:
选择那个表,右键->properties->columns->customize columns and filter(或直接用快捷键ctrl+u)->comment(前面打勾)->ok