菜单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%]