SAP Knowledge Base Article - Preview

2073231 - Table should be recreated when FK column is modified – SAP PD 16.5


  • 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.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



  • SAP PowerDesigner (PD) 16.5
  • SAP PowerDesigner 16.5 SP04
  • Oracle DBMS


SAP PowerDesigner 16.5 ; Sybase PowerAMC 16.5


CR771500, 771500, recreate, table, Foreign Key, FK column, modified , 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.