File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Obtaining Unique Constraints via dbMetaData Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Storm Applied this week in the Other Open Source APIs forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Obtaining Unique Constraints via dbMetaData" Watch "Obtaining Unique Constraints via dbMetaData" New topic

Obtaining Unique Constraints via dbMetaData

ak singh

Joined: Nov 30, 2008
Posts: 12
Hi All,
I created an unique constraint using the following queries :-

this was done as the column on which the unique constraint was being added had some on unique values.

now when i perform

it doesn't list the above added unique constraint. this is being done to create a sql script from the source user(oracle)/database(mysql) to create its copy
any help for obtaining the constraint will be appreciated.
thanks and regards
I agree. Here's the link:
subject: Obtaining Unique Constraints via dbMetaData