Forums Register Login

Obtaining Unique Constraints via dbMetaData

+Pie Number of slices to send: Send
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
Do Re Mi Fa So La Tiny Ad
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 968 times.
Similar Threads
Drop Primary Key Constraint
problem creating a foreignkey relation in compositekeys
Why a duplicate column being created for a foriegn key
Simple form-based authentication using JAAS
Foreign Key Constraint Fails
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 02:09:08.