JDBC for reading check constraints

[Dimple Bhatia <di...@gmail.com>]

Hi,
I see that Derby has implemented most methods in
java.sql.DatabaseMetaDatainterface 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

Re: JDBC for reading check constraints

[Dimple Bhatia <di...@gmail.com>]

Thanks Ramin. But how can I read info in the "REFERENCEDCOLUMNS" column in
SYS.SYSCHECKS catalog?

On 7/30/07, Ramin Moazeni <rm...@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 <di...@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
> >
>

Re: JDBC for reading check constraints

[Ramin Moazeni <rm...@gmail.com>]

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 <di...@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
>