Using JDBC to find UNIQUE and CHECK constraints

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]