wood burning stoves 2.0*
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
jQuery in Action, 2nd edition
subject: Obtaining Unique Constraints via dbMetaData
Similar Threads
Why a duplicate column being created for a foriegn key
Simple form-based authentication using JAAS
problem creating a foreignkey relation in compositekeys
Foreign Key Constraint Fails
Drop Primary Key Constraint