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

User, date Message
Written by 19774279
1 year 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
1 year ago
3958 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
1 year ago
3958 posts since Fri, 07 Apr 06 		eh, forgot the dot in the second example:

SELECT *
FROM mydb.[!proposal opens]
Written by kalvaro
1 year ago
441 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.