Created attachment 1078592 [details]
project

When creating a dynamic VDB from an existing VDB, Foreign Key definitions use the wrong table in the REFERENCES clause. The reference table is the same as the one that contains this FK.
For example, in the table SUPPLIER_PARTS, the following constraint is generated:

CONSTRAINT FK_SPLIER_PRTS_SPLY FOREIGN KEY(SUPPLIER_ID) REFERENCES SUPPLIER_PARTS(SUPPLIER_ID)

which is obviously wrong. The correct constrant definition should be:

CONSTRAINT FK_SPLIER_PRTS_SPLY FOREIGN KEY(SUPPLIER_ID) REFERENCES SUPPLIER(SUPPLIER_ID)


Steps to Reproduce:
# import the attached project
# right click the vdb, select Modeling -> Generate Dynamic VDB
# click Next, click Generate
# find the DDL for table SUPPLIER_PARTS, notice the FOREIGN KEY definitions