# Non-DBO schema in MSSQL \[Feb 24\]

**URL:** <https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 7:56am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186 "2022-11-03T07:56:57Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:56am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/1 "2022-11-03T07:56:57Z")

</div>

> 🙋‍♂️ **Rachel Ambler (She/Her)** _asked_

## Mssql - despite a bug being closed and referenced in a subsequent issue - I can’t get NoCoDb to use my schema without it falling over. Any ideas anyone? [Unable to use non-dbo schema in mssql · Issue #1342 · nocodb/nocodb · GitHub](https://github.com/nocodb/nocodb/issues/1342)

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:56am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/2 "2022-11-03T07:56:58Z")

</div>

> 💁 **o1lab** _replied_

#### The issue was closed since we never heard back on the suggestion 🙂

#### 

#### Could you please paste in the issue how `searchpath` was used

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:56am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/3 "2022-11-03T07:56:59Z")

</div>

> 🙋‍♂️ **Rachel Ambler (She/Her)** _replied_

#### It’s in my new bug report

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/4 "2022-11-03T07:57:00Z")

</div>

> 💁 **o1lab** _replied_

#### see that, thank you

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/5 "2022-11-03T07:57:02Z")

</div>

> 💁 **o1lab** _replied_

#### if you have a node setup, could you pls try connecting with a simple sample js file using knexjs ?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/6 "2022-11-03T07:57:03Z")

</div>

> 🙋‍♂️ **Rachel Ambler (She/Her)** _replied_

#### I don’t, I’m afraid.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/7 "2022-11-03T07:57:04Z")

</div>

> 💁 **o1lab** _replied_

#### the idea is if it can work with knexjs then we can use that within nocodb

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/8 "2022-11-03T07:57:06Z")

</div>

> 🙋‍♂️ **Rachel Ambler (She/Her)** _replied_

#### The documentation for knex indicates using `withSchema`

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/9 "2022-11-03T07:57:07Z")

</div>

> 🙋‍♂️ **Rachel Ambler (She/Her)** _replied_

#### I’m not a Developer by trade, and any I do is a side effect of my job as a Director of Database & BI systems. I’m pretty lost on all things `node.js`…

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/10 "2022-11-03T07:57:09Z")

</div>

> 💁 **o1lab** _replied_

#### withSchema can be skipped in query builder if connection is fine with a particular schema

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/11 "2022-11-03T07:57:10Z")

</div>

> 💁 **o1lab** _replied_

#### Im looking up knex docs as well

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/12 "2022-11-03T07:57:11Z")

</div>

> 🙋‍♂️ **Rachel Ambler (She/Her)** _replied_

#### Unsure if [Migrate into Postgres Database Schema other than 'public' · Issue #2799 · knex/knex · GitHub](https://github.com/knex/knex/issues/2799) is of any help.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/13 "2022-11-03T07:57:12Z")

</div>

> 🙋‍♂️ **Rachel Ambler (She/Her)** _replied_

#### Again, it’s seemingly PostgreSQL specific

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:57am UTC](https://community.nocodb.com/t/non-dbo-schema-in-mssql-feb-24/186/14 "2022-11-03T07:57:13Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/946081927893516368)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)