Auto suggest is grabbing columns from other schema's tables...
It looks like Auto suggest in SQLWorksheet is grabbing columns from some other schema's tables, but I don't recognize the column names from anywhere and the user I'm logged in as doesn't have any access to other schemas. Granted I don't really know where/how auto suggest is getting it's suggestions (I could guess though), perhaps someone could shed some light on this so I could get autosuggest to suggest column names in the actual table I am aliasing... Please?
select p.surname, p.given_name
from person p, user_role ur
where p.XXXXXXXX
select person_id from dep_mem where department_id = 47
when I type 'p.' (without the quotes) in line 3, I get this list of suggested columns from I don't know where...
Edited by: Christopher_M on Feb 3, 2010 7:34 AM