Thread: determine if a column is UNIQUE using metadata

Hi,

I've been trying to determine if a column is UNIQUE. I've been trying
to use the following

connection.getMetaData().getIndexInfo(null, "", "comment", false, true);

but it always says that the columns are not unique.

Am I on the right track with the above technique or should I be trying
to do something totally different?

Thanks,
Peter

On Sat, 19 Jan 2008, Peter Michaux wrote:

> I've been trying to determine if a column is UNIQUE. I've been trying
> to use the following
>
> connection.getMetaData().getIndexInfo(null, "", "comment", false, true);
>
> but it always says that the columns are not unique.
>
> Am I on the right track with the above technique or should I be trying
> to do something totally different?
>

The driver's test suite includes a test for ensuring NON_UNIQUE is
returned correctly and it works for me.  Could you post a complete example
(including table/index creation) of it failing.

Kris Jurka