SAP Knowledge Base Article - Preview

2373361 - Circular foreign keys should be generated in a separate file - SAP PD

Symptom

  • A circular dependency has been defined between tables: one table references a second table, which references the first table.
  • If the generation script is created as a single file and the foreign keys are created Outside, the generated script will execute successfully.
  • If a separate script file is created for each table, the ALTER TABLE ... ADD CONSTRAINT ... FOREIGN KEY commands are generated in each table SQL file.
  • SAP PowerDesigner displays a warning message: Do you want to generate objects which form a circular dependency? (Generation order will be ignored.)


Read more...

Environment

  • SAP PowerDesigner (PD) 16.6 SP01

Product

SAP PowerDesigner all versions

Keywords

reference, 802560, CR802560, CR#802560 , 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.