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
Author

Obtaining Unique Constraints via dbMetaData

ak singh
Greenhorn

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