jQuery in Action, 3rd edition
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
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
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Obtaining Unique Constraints via dbMetaData
It's not a secret anymore!