The result of the script you gave me: CONSTRAINTNAME TABLENAME --------------------------------------- FINDER_FK_TYPE FINDER FINDER_AMP_FK_TYPE FINDER_AMP RESOURCE_FK_TYPE RESOURCE CLAIM_FK_CONTINENT CLAIM CLAIM_FK_RESOURCE CLAIM CLAIM_FK_TYPE CLAIM CLAIM_FK_FINDER CLAIM CLAIM_FK_FINDER_AMP CLAIM
Each foreign key appears to be listed exactly once, which is good.
Btw I use the Netbean's 6.5 embedded graphical tool.
Have you asked the Netbeans team about this behavior? Perhaps they are using a different technique to query the database for foreign key information? Do you have any other DDL tools you can query the database with, to see what foreign key information they display? Perhaps SQL Squirrel, or DDLUtils, or Eclipse, etc? thanks, bryan
