This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
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