Symptom
- When modifying a Foreign Key (FK) column, e.g. changing the data type, PowerDesigner generates an ALTER TABLE table_name MODIFY column_name statement.
- Selecting the "Always use create statements" option in the Apply Model Changes to Database dialog has no effect and PD keeps generating ALTER TABLE statements.
- In the below example, executing the script generated by PowerDesigner leads to error "ORA-02267: column type incompatible with referenced column type".
- The alter.sql file should drop then create the tables and constraints again.
Read more...
Environment
- SAP PowerDesigner (PD) 16.5
- SAP PowerDesigner 16.5 SP04
- Oracle DBMS
Product
SAP PowerDesigner 16.5 ; Sybase PowerAMC 16.5
Keywords
CR771500, 771500 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.