菜单DataBase->Edit Current DBMS->Script->Objects->Column->Add中value值改成

%20:COLUMN% [%National%?national ]%DATATYPE%[%Unsigned%? unsigned][%ZeroFill%? zerofill][ [.O:[character set][charset]] %CharSet%][.Z:[ %NOTNULL%][%R%?[%PRIMARY%]][%IDENTITY%? auto_increment:[ default %DEFAULT%]][ comment '%COLNNAME%']]

如果不改原脚本会根据comment生成备注,但实际设计中我们经常只写name和code,希望comment与name一致,再写一遍comment有点麻烦。

code和displayname默认会自动填写上name的值,而comment默认空白



TABLE.COMMENT

菜单DataBase->Edit Current DBMS->Script->Objects->Table->Create中value值改成

create [%Temporary%?temporary ]table[%R%?[ if not exists]] [%QUALIFIER%]%TABLE%[
(
   %TABLDEFN%
)]comment = %.q:TNAME%
[%OPTIONS%]


原来是这样:


create [%Temporary%?temporary ]table[%R%?[ if not exists]] [%QUALIFIER%]%TABLE%[
(
   %TABLDEFN%
)][%R%?[comment = %.q:COMMENT%]]
[%OPTIONS%]


Power Designer - pdm批量将空的comment改成name