JOIN hints based on a view's underlying table's foreign key constraints
When joining views, the only suggestions currently available are for columns with the same name. It would be nice if, for simple enough views, SQL Prompt looked at the underlying tables for foreign key constraints and use them in the suggestions.
36
votes
Carlos Jourdan
shared this idea
-
David Dierckens
commented
@Joe, I have 7.5 installed, and it is not the case. Would be very nice if this would be possible.
-
Joe
commented
I believe this is the default behavior in SQL Prompt 7 now