Toad World® Forums

ANSI Join converter wrongly add schema


#1

Hi

TOAD 12.10 can convert

SELECT *
  FROM table1 t1, table2 t2
  WHERE  t1.code = t2.code(+);

to

SELECT * 
FROM myschema.table1 t1 LEFT OUTER JOIN myschema.table2 t2 f ON ( t1.code = t2.code);

The problem is there is no reason for adding the current schema name (myschema) before the table names. In our environment, this leads to bugs.

Can this be changed ?
Thanks