powerDesigner遇到的一些问题解决方法

问题

constraint name uniqueness,existence of index column

Reference constraint name maximum length is limited to 7 characters

Key constraint name maximum length is limited to 7 characters

Table code maximum length

Key constraint name maximun length is limited to 15 characters

Column code maximum length

默认生成的SQL语句(表名、字段名等)都带双引号，导致用SQLPlus插入Oracle数据库时表名与表列都带""号   解决方法 点击右键选择Automatic correction 菜单：Database=>Edit current DBMS PGSQL73::Script/Objects/MaxConstLen value=>255 PGSQL73::Script/Objects/Table/Maxlen value=>255 修改DataBase->Edit Current DBMS->Script->Objects->MaxConstLen值为128 Database=>Edit current DBMS 数据库类型::Script/Objects/Column/Maxlen value=>255  但是要注意的是，表名、列名、主键等不要超过30个字符，否则Oracle不认。   Database-> Edit Current DBMS...-> Script-> Sql->  Format-> CaseSensitivityUsingQuote 改为No