db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anjana Prakash <anjana.prak...@actian.com>
Subject RE: Query to fetch table name based on their constaints
Date Sun, 13 Dec 2015 20:09:46 GMT
Thanks Bryan. 
I referred to the below API and could get reference to get foreign key and primary key table.


-----Original Message-----
From: Bryan Pendleton [mailto:bpendleton.derby@gmail.com] 
Sent: Friday, December 11, 2015 7:57 PM
To: derby-dev@db.apache.org
Subject: Re: Query to fetch table name based on their constaints

On 12/11/2015 3:56 AM, Anjana Prakash wrote:
> Hi ,
> Has anyone tried to retrieve table name based on their constraints.

Often you can do this sort of thing using JDBC's DatabaseMetaData:


Alternately, have a look at the Derby system tables, which you can write arbitrary queries



View raw message