Go to powerdesigner to convert the table name during design into SQL comments

Source: Internet
Author: User

In powerdesigner 12, convert the table name at design time to SQL annotation (Oracle)

PD is a very powerful database design and modeling tool. When I recently used it, I forgot how to convert the table name to the notes in SQL. I found it for a long time, finally, we found that setting in this place:
Datebase generation under the Datebase menu or press Ctrl + G

In addition, if you use a package in the modeling project, you may not be able to export any tables during export (SQL), you can set the following:

Select all the tables and SEQ below to export

Some other settings of Pd (G-out ):
1. In the table design module, only the table name is displayed. Right-click a blank area in physical diferences, select disaplay preferences, and remove data types from the table menu.
2. The name and code of the table design do not change simultaneously: in the dialog menu of general options, remove name to code mirroing from operating modes.

 

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.