+2

sql joins autocomplete based on database structure and foreign keys

Darius Val 11 year бұрын 0

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"