Re: Using JDBC to find UNIQUE and CHECK constraints

Hi Simon,

Currently it is necessary to query the system tables in the SYS_INFO 
schema for this information.  I suggest using a query tool to explore 
the SYS_INFO schema.

Toby.

Simon Ness wrote:

> Hi,
> 
> Is there a way to find all of a table's constraints using JDBC?
> 
> I can find primary keys and foreign keys pretty simply using the
> DatabaseMetaData methods getPrimaryKeys and getImportedKeys, but have
> yet to find a way to find out other details of a table specified in
> the original create statement.
> 
> These include, the two other types of constraint, validation checks
> and the unique constraint.  Also a column's index_type.  I have tried
> using the function getIndexInfo, yet this produces an empty ResultSet.
> 
> I have looked through the archieves but could not find any threads
> relating to this question.  If it has been asked though, please point
> me of in the right direction...
> 
> Thanks for your time,
> 
> Simon.



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]