Return
-
Title
Cannot see table and columns when typing queries in the editor -
Description
Unable to see tables and columns when typing queries in the editor. -
Cause
Customer is querying directly using table names without the schema. -
Resolution
Ensure that "Preload objects on 'Load Object from DB' window" is ticked.
View | Options | Editor | Behaviour
When querying, this format has to be followed:
select * from <schema>.<table_name>