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

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

19774279 posted 5 years ago in General
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".
ansgar posted 5 years ago
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]
ansgar posted 5 years ago
eh, forgot the dot in the second example:
SELECT *
FROM mydb.[!proposal opens]
kalvaro posted 5 years ago
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.