distal-attribute
distal-attribute
distal-attribute
distal-attribute

Is there any key like "Alt+/" in Eclipse when I'm writing SQL Query?

User, date Message
Written by 19774279
2 years ago
Category: General
1 posts since Thu, 22 Mar 12
For example, if I type "s", and press some keys, it will tell me all the Object begin which "s" such as "SELECT","SET" or some databases/tables begin with "s".
Written by ansgar
2 years ago
4967 posts since Fri, 07 Apr 06
Ah, you mean a completion proposal. Yes, HeidiSQL has such a thing. In a query editor, press Ctrl+Space to invoke it manually. Also when you type a dot - for example after a table alias - Heidi will propose you all column names in that table:

SELECT *
FROM mytable AS m
WHERE m.[!proposal opens]



Or all tables from a database:

SELECT *
FROM mydb[!proposal opens]

Written by ansgar
2 years ago
4967 posts since Fri, 07 Apr 06
eh, forgot the dot in the second example:

SELECT *
FROM mydb.[!proposal opens]

Written by kalvaro
2 years ago
591 posts since Thu, 29 Nov 07
BTW, there's a tiny exception to the auto-completion that's always bugging me:

SELECT mytable.x[proposal opens]
FROM mytable



SELECT foo.x[proposal opens]
FROM mytable foo



SELECT x[no proposal!]
FROM mytable



Not sure if there's a simple fix to this :-?
 

Please login to leave a reply, or register at first.