+2
sql joins autocomplete based on database structure and foreign keys
Hello,
It would be really great feature to have this. Lets say I write such sql:
SELECT event_names.event_name, coefs.event_value FROM coefs
INNER JOIN event_names ON event_names.id = coefs.event_names_id
the part:
ON event_names.id = coefs.event_names_id
is always the same when I join this event_names table to coefs table. So it takes time to type that. And there are many situations like this.
So think sublime could rread database structure and save it in a file.
WHen I type
SELECT event_names.event_name, coefs.event_value FROM coefs
INNER JOIN event_names
it could automatically suggest "ON event_names.id = coefs.event_names_id"
Service d'assistance aux clients par UserEcho