Is there a way to have Toad highlight table names for tables in other schema? I am able to get Toad to highlight tables in the schema I am logged in as, but if I type the name of a table in an other schema the highlighting does not take effect.
For example....select * from user2.tablename
If I am user1 but have read access to user2.tablename, can user2.tablename still have syntax highlighting?
To support syntax highlighting of table names we must query for them. We do this for the current user by SELECT TABLE_NAME FROM USER_TABLES. This query is relatively fast. When you want to get other usernames involved, then you now need to query ALL_TABLES or DBA_TABLES. This query will not be as fast. On large databases the delay could be aggravating. For this reason management has opted to not expand our scope beyond the connected schema. The pain is not worth the gain in this case.
