Schema and Db with the same name: no Db suggestions

buckley

Hi,

i don't know if its by design but if there is a schema in the current database that has the same name as a database then suggestions for the other database will not show up. Took me a while to figure out the cause. What do you think?

Kr, Tom

Aaron L

Hi Tom,

There was a fix put in to reduce the full cross-database suggestions if a schema and a database shared the same name. The related forum post is here - where MobyDX had both a schema and a database with the name "ERP".

It should still offer suggestions for the database after the database and schema qualification are inserted, but it won't offer the fully expanded suggestions for that database straight off the bat as it lead to the problem that MobyDX was seeing.

Thanks,
Aaron.