| Author |
Message |
|
2007/06/12 03:26
|
|
|
orientphoebus
Joined: 2005/12/02
Messages: 3
Offline
|
|
|
|
I have a table's primary key is a foreign key also. The generated ERD cannot display the relationship.
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
| Description |
|
Download
|
| Filesize |
1 kb
|
| Downloaded: |
104 time(s) |
|
|
|
|
 |
| |
|
|
2007/06/18 08:45
|
|
|
Jick
Joined: 2005/04/29
Messages: 2880
Offline
|
|
|
|
Hi orientphoebus,
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
|
Visual Paradigm International Ltd.
http://www.visual-paradigm.com
Build Quality Applications Faster, Better and Cheaper |
|
|
|
|
| |
|
|
2007/06/22 01:08
|
|
|
|
|
|
I found this is a fault alarm. This problem happened when I didn't grant the select privilege to the user I used in VPUML. After doing that. Everything is fine.
|
|
|
|
|
| |
|
|
2007/06/22 09:12
|
|
|
Jick
Joined: 2005/04/29
Messages: 2880
Offline
|
|
|
|
Hello orientphoebus,
That's ok. Please feel free to contact us again if there are any questions.
Best regards,
Jick
|
Visual Paradigm International Ltd.
http://www.visual-paradigm.com
Build Quality Applications Faster, Better and Cheaper |
|
|
|
|
| |
