db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: What cause this?
Date Sun, 14 Dec 2008 15:46:08 GMT
> 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




Mime
View raw message