PowerDesigner generated Oracle built-in script to remove the quotation number of lowercase objects

This time I used pd to design the database. I didn’t pay attention at first. All table names and field names are in lowercase letters. As a result, all the objects in the generated script were quoted, so I didn’t want to change so many tables and fields one by one, so I looked for a solution, and the result was really found (it seems that pd only supports uppercase and lowercase by default) The table name or field will be automatically quoted in the script )< br>
Database->Edit current database->Script->Sql->Format , there is one item CaseSensitivityUsingQuote , its comment < span style="margin:0px; padding:0px; font-family:宋体; font-size:14px">为 “Determines if the case sensitivity for identifiers is managed using double quotes” , indicating whether double quotes apply The case of the identifier can be seen on the right side values The default value is “YES”, Change to “No” That’s it!

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 840 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.