[JDBC] determine if a column is UNIQUE using metadata

From: Peter Michaux <petermichaux(at)gmail.com>
Date: Sat Jan 19 2008 - 19:43:00 EST

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

---------------------------(end of broadcast)---------------------------

TIP 2: Don't 'kill -9' the postmaster Received on Sat Jan 19 19:45:07 2008