# MS SQL Schema doesn't detect in Named Query Builder

**URL:** <https://forum.inductiveautomation.com/t/ms-sql-schema-doesnt-detect-in-named-query-builder/60608>\
**Category:** Ignition Early Access\
**Created:** [June 10, 2022, 1:02pm UTC](https://forum.inductiveautomation.com/t/ms-sql-schema-doesnt-detect-in-named-query-builder/60608 "2022-06-10T13:02:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [June 10, 2022, 1:02pm UTC](https://forum.inductiveautomation.com/t/ms-sql-schema-doesnt-detect-in-named-query-builder/60608/1 "2022-06-10T13:02:53Z")

</div>

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!!!

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/f/df9989c74a02e3109ec6cb9aa8dffba7575856d7.png)

---

<div class="post-metadata">

**Author:** ![nick.schuetz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nick.schuetz/32/6160_2.png) [@nick.schuetz](https://forum.inductiveautomation.com/u/nick.schuetz)\
**Post date:** [June 10, 2022, 1:14pm UTC](https://forum.inductiveautomation.com/t/ms-sql-schema-doesnt-detect-in-named-query-builder/60608/2 "2022-06-10T13:14:41Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/8/18f67fbc030e33a5e9487c2a2e3b8ad1e054a0b4.png)

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [June 10, 2022, 4:54pm UTC](https://forum.inductiveautomation.com/t/ms-sql-schema-doesnt-detect-in-named-query-builder/60608/3 "2022-06-10T16:54:38Z")

</div>

Thanks, it solve the problem

---

<div class="post-metadata">

**Author:** ![bmusson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmusson/32/87530_2.png) [@bmusson](https://forum.inductiveautomation.com/u/bmusson)\
**Post date:** [June 11, 2022, 9:22pm UTC](https://forum.inductiveautomation.com/t/ms-sql-schema-doesnt-detect-in-named-query-builder/60608/4 "2022-06-11T21:22:39Z")

</div>

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