3 ms·
I mean, it works either way. Once you type the column names, it can guess the table name easily. I use DataGrip at work and it can complete the column names w
by jrockway 8y ago
I mean, it works either way. Once you type the column names, it can guess the table name easily.
I use DataGrip at work and it can complete the column names without knowing the table name, so it ends up not being a problem.
- dragonwriter 8y ago> Once you type the column names, it can guess the table name easily. If the query is simple enough that a natural join would work and you aren't doing FROM clause aliasing (which can be useful to make reusable queries self-documenting), sure. For more complex queries and obviously any time table or column aliasing are used, that becomes somewhere between less likely and logically impossible.