It’s been a while since my last post. Days ago I noticed that every time I reverse engineer an Oracle database, for some reason the unique constraints declared on a column are not loaded into the view (E-R diagram). Also, this is problematic because when I generate the code for the changes that I made (update database), any attempt to create foreign keys to the columns with the unique constraint are not generated for obvious reasons.
I also tried declaring “unique” one of the columns that had the missing constraint, but still, when I chose “update database”, the ALTER statement for that change didn’t appear in the generated DDL file, and thus, the foreign keys I created also are not showing up.
Is this a known issue or am I missing something?
Thanks in advance,