PowerDesigner_常用设置（国外英文资料）.doc

PowerDesigner_常用设置（国外英文资料） PowerDesigner_ common Settings and -- 2010-04-29 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # -- /skyangell/archive/2009/09/19/1569931.html The table name in the SQL statement is removed from the quotation mark in front of the field name: When you open the CDM, go to the tool-model Options - Naming Convention, and set the Charcter case Options of Name and Code to Uppercase or Lowercase, as long as its not Mixed case! Or select the Database - Edit current Database Sql - - Script - Format, there is a CaseSensitivityUsingQuote, its the comment for Determines if the case sensitivity for identifiers is managed using double quotes, indicates whether or not the double quotation marks to provisions shall be applicable to the identifier of the case, you can see on the right side of the values of the default value is YES, can be changed to No! Or, in the case of PDM, go to the tool-model Options - Naming Convention, and set the Charcter case option for Name and Code to Uppercase! When you modify the name, the value of the code changes, which is very inconvenient Modified method: in the Options menu in the PowerDesign modification, in [Tool] - [General Options] - [Dialog] - [Operating modes] - [Name to Code mirroring], here the default is to get the Name and Code synchronization, will the check box in front of the cut off the line. When a table script is generated by the PDM, the error (oracle) occurs when the field exceeds 15 characters. For the unknown reason, the solution is to open the PDM and the menu bar of the Database will appear, and enter the database-edit Current dbms-script-objects -column-maxlen, which will make the value variable larger (the original 30), for example, to 60. There are also errors in the length of the table or any other object that can be selected for the corresponding object. Or use this method: When you generate a table scrip