http://forums.visual-paradigm.com/posts/17.html JForum - http://www.jforum.net
If I change the "PRIMARY KEY" to "UNIQUE" it works. But as the DB allow me to create a primary key is a foreign key, the reverse shall be able to deal with it.

Also with the ParentTable "TestTable", if I keep the primary key definition there, the reversed ERD cannot display any columns of this table.

Another problem: Even if I changed the PK to UK:
constraint TestChild1_UK UNIQUE (ParentID),
The reverse DB gave me the relationship in the ERD, but the ParentID column was missing in TestChild1.


This problem I am having is with Sybase ASE 12.5

Thanks
]]> http://forums.visual-paradigm.com/posts/2246#17795.html http://forums.visual-paradigm.com/posts/2246#17795.html
Thank you for your post. We will test the problem and come back to you. Meanwhile, please feel free to let me know if there are any questions.

Best regards,
Jick
]]> http://forums.visual-paradigm.com/posts/2246#17858.html http://forums.visual-paradigm.com/posts/2246#17858.html http://forums.visual-paradigm.com/posts/2246#17935.html http://forums.visual-paradigm.com/posts/2246#17935.html
That's ok. Please feel free to contact us again if there are any questions.

Best regards,
Jick]]> http://forums.visual-paradigm.com/posts/2246#17941.html http://forums.visual-paradigm.com/posts/2246#17941.html