View Single Post

   
  #1 (permalink)  
Old 04-16-2008, 12:59 AM
Peter Michaux
 
Posts: n/a
Default 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote