2013 Jun 11 12:06 PM - edited 2013 Jun 11 2:06 PM
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.
Request clarification before answering.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:)
Move origin and move destination let you change the origin or destination point of a foreign key vector with the keyboard (for keyboard accessibility).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.