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.


Anjana. 

-----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:

http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html

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

http://db.apache.org/derby/docs/10.11/ref/rrefsistabs38369.html

bryan



Mime
View raw message