How to get the schema name to prepend a table reference when dragging a table to the console?
Answered
I'm using DataGrip to connect to an Oracle database. I'm logging in with a schema (let's say 'X') that has access to other schemas ('Y' and 'Z').
When I drag a table from the Y or Z schema into the console, DataGrip only inserts the table name. I expect to see: 'Y.TABLE', but I only get 'TABLE'
Of course, when I right click on the table and choose 'Copy Reference' I get the right reference. But dragging and dropping should produce the same result, in my opinion.
I've searched through the Setting and the connection properties, but I haven't found any settings that impact this behavior. How can I get this to work?
Please sign in to leave a comment.
At the moment there is no way. I added your description to the corresponding issue https://youtrack.jetbrains.com/issue/DBE-4127
Just to add. This is a great idea especially when users (like in our case) are using OTAP so that same table namens are created under different schema's.
You can use parameters though, but e.q. the Db2 environment requires a proper schema name here.
So I hop this will get many votes in order to get this option in place ;)