This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Is there a way to determine 'UNIQUE' constraints? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Is there a way to determine Watch "Is there a way to determine New topic
Author

Is there a way to determine 'UNIQUE' constraints?

nico dotti
Ranch Hand

Joined: Oct 09, 2007
Posts: 124
I'm so close to getting everything I need from metadata to dynamically create a build.sql scxript, but I don't see a way to get UNIQUE constraints (not PK's or FK's though they should be unique I actually mean UNIQUE sql constraint). Looking for something like:

resultSetMetaData.isUnique(column)

Any suggestion? Thanks all.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Is there a way to determine 'UNIQUE' constraints?
 
It's not a secret anymore!