# SQL Database name auto regenerated

**URL:** <https://forum.inductiveautomation.com/t/sql-database-name-auto-regenerated/55472>\
**Category:** Ignition\
**Tags:** ignition80, database, vision\
**Created:** [January 28, 2022, 9:22am UTC](https://forum.inductiveautomation.com/t/sql-database-name-auto-regenerated/55472 "2022-01-28T09:22:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nikunj.pipariya](https://avatars.discourse-cdn.com/v4/letter/n/cc9497/32.png) [@nikunj.pipariya](https://forum.inductiveautomation.com/u/nikunj.pipariya)\
**Post date:** [January 28, 2022, 9:22am UTC](https://forum.inductiveautomation.com/t/sql-database-name-auto-regenerated/55472/1 "2022-01-28T09:22:30Z")

</div>

I have set the table name regeneration on every 1 year. But I am experiencing that the ignition has autogenerated new table name rather than using the current one. I am in need of the help for the reason of this issue. If anyone can help me with this please revert me back.

---

<div class="post-metadata">

**Author:** ![jonathan.taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonathan.taylor/32/4048_2.png) [@jonathan.taylor](https://forum.inductiveautomation.com/u/jonathan.taylor)\
**Post date:** [January 28, 2022, 10:31am UTC](https://forum.inductiveautomation.com/t/sql-database-name-auto-regenerated/55472/2 "2022-01-28T10:31:08Z")

</div>

What is the context of this?

Are you talking about Tag History, or a self made table?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 28, 2022, 12:51pm UTC](https://forum.inductiveautomation.com/t/sql-database-name-auto-regenerated/55472/3 "2022-01-28T12:51:47Z")

</div>

Ignition injects a unique suffix to prevent data from multiple sources mixing (different servers pointing at the same DB). You must have changed something to make the tag historian think the previous data no longer belonged to itself. What did you change?

---

<div class="post-metadata">

**Author:** ![nikunj.pipariya](https://avatars.discourse-cdn.com/v4/letter/n/cc9497/32.png) [@nikunj.pipariya](https://forum.inductiveautomation.com/u/nikunj.pipariya)\
**Post date:** [February 21, 2022, 7:38am UTC](https://forum.inductiveautomation.com/t/sql-database-name-auto-regenerated/55472/4 "2022-02-21T07:38:35Z")

</div>

I am talking about new table getting generated in sql database automatically. Though I have set to create a new table every year.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [February 21, 2022, 8:16am UTC](https://forum.inductiveautomation.com/t/sql-database-name-auto-regenerated/55472/5 "2022-02-21T08:16:42Z")

</div>

I think you would need to give a lot more detail before anyone could help you.

- What are the names of the tables?
- When did you expect the next year’s table to be created?
- When did it actually get created?
- What settings have you changed?