Re: Obtaining info on UNIQUE constratints.

2007-10-02 Thread Tim Dudgeon
Rick Hillegas wrote: Tim Dudgeon wrote: How do you find out which UNIQUE constraints exist for a table, and which columns they use? DatabaseMetaData.getIndexInfo( ... ) can give me the information about the indexes, but it seems that in Derby a UNIQUE index is not the same thing as a UNIQUE

Re: Obtaining info on UNIQUE constratints.

2007-09-25 Thread Rick Hillegas
Tim Dudgeon wrote: How do you find out which UNIQUE constraints exist for a table, and which columns they use? DatabaseMetaData.getIndexInfo( ... ) can give me the information about the indexes, but it seems that in Derby a UNIQUE index is not the same thing as a UNIQUE constraint. Thanks

Obtaining info on UNIQUE constratints.

2007-09-24 Thread Tim Dudgeon
How do you find out which UNIQUE constraints exist for a table, and which columns they use? DatabaseMetaData.getIndexInfo( ... ) can give me the information about the indexes, but it seems that in Derby a UNIQUE index is not the same thing as a UNIQUE constraint. Thanks Tim