cancel
Showing results for 
Search instead for 
Did you mean: 

How do I get ER Diagram "Move origin" to actually do something?

Breck_Carter
Participant
4,888

In SQL Anywhere 16 the Sybase Central ER Diagram tab presents two right-mouse menu options on the foreign key icons that have me baffled: Move origin and Move destination.

What do they do, and how do I get them to do it?

...there is [cough] little in the way of docs for the ER Diagram feature.


How do I get ER Diagram Move origin to actually do something

Accepted Solutions (0)

Answers (3)

Answers (3)

Breck_Carter
Participant

Got it!

When you click on a foreign key box (as in the image shown) two tiny black squares appear in the centers of the parent and child table boxes (you can see them in the image, I can see them too... now 🙂

These teeny tiny black boxes might appear to the GUIclueless as flyspecks on the monitor, but they can be clicked and dragged to cause the foreign key line to move. This is a cosmetic graphics operation, not (as I was thinking) a series of energetic ALTER TABLE statements to rearrange the referential integrity definitions.

Well, hey, forgive me for getting carried away! The ER Diagram feature is pretty [redacted] slick now, when did that happen? Stay tuned for an enthusiastic blog post...

VolkerBarth
Contributor

not (as I was thinking) a series of energetic ALTER TABLE statements to rearrange the referential integrity definitions

That's what I was thinking, too. - The doubled clueless staff:)

Former Member

Move origin and move destination let you change the origin or destination point of a foreign key vector with the keyboard (for keyboard accessibility).

Breck_Carter
Participant
0 Kudos

Thanks, but... you completely misunderstood my level of cluelessness 🙂

Here's a cartoon that might help (hint: I'm NOT Dilbert)...

alt text

Former Member

As soon as I read "Move origin and Move destination", I assumed that would change the RI defs. That would've been awesome, but alas...

Breck_Carter
Participant
0 Kudos

Awesome, yes... but trust me, we really don't want the Software Gods at Watcom spending their time (re)creating PowerDesigner. The end result would be monstrous bloatware... how do I know that? I've used PowerDesigner 🙂