join
When typing "JOIN [start of table name]" I would like the suggestions shown by SQL Complete to be based on the foreign keys and [start of table name] instead as now, when it highlights the first table based on [start of table name].
Example:
in my database I have a UserAccount and a UserSecurityRole table that are joined by a foreign key so when I start typing
SELECT * FROM UserAccount ua
JOIN User
SQL Complete shows all tables starting with "User" but the one highlighted in the suggestions list i UserAccount instead of UserSecurityRole with a foreign key, so in order to highlight and easily select UserSecurityRole I have to type more of the name which in some other cases are tedious as some table names are quite similar and long.
My suggestion is that the highlighted table is the first one based on the typed name AND has a foreign key.
-
AdminDevart (_, Devart) commented
Hi,
Thanks for your patience!
Just want to inform you that it is already implemented.
So we would like to suggest updating to the latest version and check there.
Best,
Devart Support Team