@Marco
Is it possible that I dont have access to some system table, gaining which will help in a faster dropdown?
Also, why can I access the drop down only when I use the schema name explicitly and not otherwise?
Regards,
Shubham
Hi
I rely heavily on the code assistant to complete my tables et al, and cant seem to make it work the way I want:
Using the below sequence:
1) ALTER SESSION SET SCHEMA_NAME = MYSCHEMA;
2) SELECT * FROM [TABLE];
3) SELECT * FROM MYSCHEMA.[TABLE];
If I dont put in Step 1, Step 2 doesn't work...