Sometimes when I am working with alias of a public synonym, the dot lookup doesnt work.
For example,
SELECT * FROM emp e where e.
Given, that emp is a public synonym, when I type e. no column shows up after the period.
The issue with the dot-look up has to do with not only using a synonym with the same name as a table but also not ending queries with a semi-colon.
WORKAROUND:
Make sure you end all queries with a semi-colon.
STATUS:
Waiting for fix in a future release of SQL Navigator.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center