db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dimple Bhatia" <dim...@gmail.com>
Subject Re: JDBC for reading check constraints
Date Mon, 30 Jul 2007 19:34:30 GMT
Thanks Ramin. But how can I read info in the "REFERENCEDCOLUMNS" column in
SYS.SYSCHECKS catalog?

On 7/30/07, Ramin Moazeni <rmoazeni@gmail.com> wrote:
>
> Hi Dimple
>
> I don't think there is a way to retrieve CHECK constraint info.
> For this, you may have to directly query the Derby system catalogs. You
> may have to join between constraints catalog with tables catalog and
> pick out information you need.
>
> Ramin
>
> On 7/30/07, Dimple Bhatia <dimp20@gmail.com> wrote:
> > Hi,
> > I see that Derby has implemented most methods in
> java.sql.DatabaseMetaData
> > interface but I did not see any way to retrieve CHECK constraints from
> the
> > database in java.sql.DatabaseMetaData. So How does an application
> retrieve
> > CHECK constraints from Derby?
> >
> > Thanks
> > Dimple
> >
>

Mime
View raw message