# Transaction Group ID **URL:** \ **Category:** Ignition\ **Tags:** ignition79\ **Created:** [October 25, 2018, 10:35am UTC](https://forum.inductiveautomation.com/t/transaction-group-id/20366 "2018-10-25T10:35:17Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![luca.mori](https://avatars.discourse-cdn.com/v4/letter/l/5daacb/32.png) [@luca.mori](https://forum.inductiveautomation.com/u/luca.mori)\ **Post date:** [October 25, 2018, 10:35am UTC](https://forum.inductiveautomation.com/t/transaction-group-id/20366/1 "2018-10-25T10:35:17Z")
Hi guys, working on a project with the release 7.9.6, I’m trying to let the transaction group create a database table, I noticed that even if I take off the “use custom index column”, Ignition still create the index column. Is there any way to exclude the index column at all ? ---
**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:** [October 25, 2018, 11:10am UTC](https://forum.inductiveautomation.com/t/transaction-group-id/20366/2 "2018-10-25T11:10:27Z")
No. But if you turn that checkbox back off after the table is created, you can delete that index column manually. Be sure to manually set up a different primary key, or performance will suck. ---
**Author:** ![luca.mori](https://avatars.discourse-cdn.com/v4/letter/l/5daacb/32.png) [@luca.mori](https://forum.inductiveautomation.com/u/luca.mori)\ **Post date:** [October 25, 2018, 11:28am UTC](https://forum.inductiveautomation.com/t/transaction-group-id/20366/3 "2018-10-25T11:28:13Z")
Ok thanks. What i was looking for was to load a dataset from a sql query and then bind this dataset to a table and a chart. The problem is that the chart require a dataset where the first column is a DATETIME, so for simplicity I was trying to let the transaction group create a table built like this, whit no ID and whit a first column as DATETIME. At this point i recon that the only reason it will be to filter my column within the sql code. Thanks for your time.