# Table schema in transaction group target

**URL:** <https://forum.inductiveautomation.com/t/table-schema-in-transaction-group-target/39151>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [September 28, 2020, 10:54pm UTC](https://forum.inductiveautomation.com/t/table-schema-in-transaction-group-target/39151 "2020-09-28T22:54:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\
**Post date:** [September 28, 2020, 10:54pm UTC](https://forum.inductiveautomation.com/t/table-schema-in-transaction-group-target/39151/1 "2020-09-28T22:54:05Z")

</div>

Can you specify table schema like this in a transaction group?

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/e/5e2b52664384e5c21f76dd4abe16b15df615e9b4.png)

This group is full of hour meters. If I stop and start the group, it will read initial values from the table like I expect, but then when it executes it doesn’t (seem to) write the new values out to the table. Has anybody seen a problem like this?

---

<div class="post-metadata">

**Author:** ![Paullys50](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paullys50/32/3324_2.png) [@Paullys50](https://forum.inductiveautomation.com/u/Paullys50)\
**Post date:** [September 29, 2020, 10:42am UTC](https://forum.inductiveautomation.com/t/table-schema-in-transaction-group-target/39151/2 "2020-09-29T10:42:28Z")

</div>

Yes, there is a checkbox under the advanced section of the DB connection page on the gateway, don’t recall what it is called but it will expose the schema should the option be checked.

---

<div class="post-metadata">

**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\
**Post date:** [September 29, 2020, 2:09pm UTC](https://forum.inductiveautomation.com/t/table-schema-in-transaction-group-target/39151/3 "2020-09-29T14:09:16Z")

</div>

I assume you mean Include `Include Schema in Table Name`. If I enable this will it cause the other references that don’t include a schema name to fail?

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

---

<div class="post-metadata">

**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\
**Post date:** [October 1, 2020, 10:07pm UTC](https://forum.inductiveautomation.com/t/table-schema-in-transaction-group-target/39151/4 "2020-10-01T22:07:01Z")

</div>

The problem wasn’t related to the schema name. The problem was that the default index column didn’t exist. When I changed the transaction group to use a custom index, everything worked as expected.