Summary of common functions of PowerDesigner

Source: Internet
Author: User
Tags powerdesigner

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.