# Change Schema Name

**URL:** <https://forum.inductiveautomation.com/t/change-schema-name/43690>\
**Category:** Ignition\
**Created:** [February 22, 2021, 8:10pm UTC](https://forum.inductiveautomation.com/t/change-schema-name/43690 "2021-02-22T20:10:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [February 22, 2021, 8:10pm UTC](https://forum.inductiveautomation.com/t/change-schema-name/43690/1 "2021-02-22T20:10:15Z")

</div>

I never changed my original DB schema name when I first started to use Ignition, so it is still named `test`. Is there any danger in renaming it as long as I update the DB connection in the Ignition gateway?

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [February 22, 2021, 8:17pm UTC](https://forum.inductiveautomation.com/t/change-schema-name/43690/2 "2021-02-22T20:17:32Z")

</div>

Any scripts or otherwise that are using that DB in any way other than assuming it is the default?

For instance:

```auto
system.db.runQuery("YOUR QUERY",'test')

```

There is the risk that a significant portion of things could stop working because the DB named ‘test’ doesn’t exist any longer.

Also any scripts in the gateway context where the database name is required would need to be updated.

---

<div class="post-metadata">

**Author:** ![WillMT10](https://avatars.discourse-cdn.com/v4/letter/w/7feea3/32.png) [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\
**Post date:** [February 22, 2021, 8:30pm UTC](https://forum.inductiveautomation.com/t/change-schema-name/43690/3 "2021-02-22T20:30:37Z")

</div>

If you leave the DB connection name untouched and ONLY change the name of the schema in the database, then the only risk I can think of off the top of my head is breaking any queries that call out the schema name directly. Example:

```auto
SELECT col1, col2 FROM test.table1

```

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [February 22, 2021, 9:12pm UTC](https://forum.inductiveautomation.com/t/change-schema-name/43690/4 "2021-02-22T21:12:16Z")

</div>

I made sure all named queries etc uses `<default>` connection (where applicable) just to be sure. 🙂