MS SQL Schema doesn't detect in Named Query Builder

Hello,
As shown in the following image we have some schema and in each schema, we have a table named “Main”. The problem with the named query builder menu is distinguishing between tables and repeating columns 2 or 3 times!!!

Have you selected this setting in the advanced settings area? You may need to restart your designer after modifying the setting.

3 Likes

Thanks, it solve the problem

Huh, I never knew that setting existed. That’s so much easier than having separate connections for each schema.