Show comment columns when designing a table in 1.PowerDesigner comment
Select the table you want to edit, right-click Properties, Columns, Customize Columns and Filter, Comment, OK, or use the shortcut key right- > "Properties", "Columns", "Ctrl+u", "Comment", "OK"The value of setting code in 2.powerdesigner does not change with the name value (that is, the problem with the name and code) Setup method: Tools->general options->dialog->name to Code mirroring (before the tick is removed). 3. There are no line comments in the generated statement, so you have to add these annotations manuallyAt the Database-->edit current DBMS ... Set the DBMS's properties to find Mysql5.0-->script-->objects-->column-->add to put the original content:%20:column% [%national%?national]%D atatype%[%unsigned% unsigned][%zerofill%? zerofill][[. O:[character Set][charset]]%charset%][. z:[%notnull%][%identity% auto_increment:[Default%default%]][comment%.q: @OBJTLABL%]] instead:%20:column% [%national%? National]%datatype%[%unsigned% unsigned][%zerofill%? zerofill][[. O:[character Set][charset]]%charset%][. z:[%notnull%][%identity% auto_increment:[default%default%]][comment%.q:comment%]] hehe, In fact, only the last objtlabl changed to comment on the line. Before the objtlabl don't know what to refer to, know the friend tell ... The generated code has a comment for each field:Notes for the table:The default should be a table comment, if not, you can root out the following methods to set. Set the properties of the DBMS, locate Mysql5.0-->script-->objects-->table-->tablecomment:value, and add the following alter Table [%qualifier% The following statement is generated when the]%table% comment%.60qa:comment% is added:?
1 |
ALTER TABLE code comment ' Codes table '; |
Code generation: Click menu database-->generate Database Generation screen: In Format tab, tick generate name in empty Comment Click OK to generate the corresponding code, the above comment will appear in the code. This is the connection found on the Internet: https://my.oschina.net/yale8848/blog/169275http://www.easytd.com/jingyanjiaoliu/d_14112311201.html
Summary of common functions of PowerDesigner