Special icon for Foreign Key relationship JOIN candidates

DavidHerbst

First of all, thank you so much for adding Foreign Key relationship JOIN candidates to the top of the JOIN candidate list in the 3.5 release!

Now would it be possible for you to enhance SQL Prompt to use a special icon for these candidates to distinguish them from the other table candidates?

Thanks,
David

JasonC

That is a neat idea. A key-paperclip would be kinda cool.

In some situations it is obvious which ones are the foreign-key relationships, since they are the suspiciously-non-alphabetical-suggestions, but in some situations it is not obvious at all (e.g. if the foreign key relation is the first one alphabetically). So cheers for the suggestion, we'll look into this one for the next release.

DavidHerbst

Thanks Jason!

JasonC

We have implemented this and it should be available in the upcoming SQL Prompt 3.6. Thanks again for your suggestion.