What are the challenges you face when working across database platforms? Take the survey
Options

Schema and Db with the same name: no Db suggestions

buckleybuckley Posts: 69 New member
edited May 27, 2016 5:08AM in SQL Prompt
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

Comments

  • Options
    Aaron LAaron L Posts: 596 New member
    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.
Sign In or Register to comment.