# Index Column Doesn't Increment

**URL:** <https://forum.inductiveautomation.com/t/index-column-doesnt-increment/25868>\
**Category:** Ignition\
**Created:** [June 17, 2019, 2:00pm UTC](https://forum.inductiveautomation.com/t/index-column-doesnt-increment/25868 "2019-06-17T14:00:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jonathan.greene](https://avatars.discourse-cdn.com/v4/letter/j/ecd19e/32.png) [@jonathan.greene](https://forum.inductiveautomation.com/u/jonathan.greene)\
**Post date:** [June 17, 2019, 2:00pm UTC](https://forum.inductiveautomation.com/t/index-column-doesnt-increment/25868/1 "2019-06-17T14:00:29Z")

</div>

I am using Ignition 7.6. I have created a new table in MSSQL database for charting. I have setup a Historical Transaction Group and added the SQL tags that I want. It is executed and running but the Index Column is recording null values. All other data is recording in to the database.

---

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [June 17, 2019, 2:12pm UTC](https://forum.inductiveautomation.com/t/index-column-doesnt-increment/25868/2 "2019-06-17T14:12:06Z")

</div>

I would guess that when you created the database you did not specify the index column to auto increment.

This is done within SQL Server.

---

<div class="post-metadata">

**Author:** ![jonathan.greene](https://avatars.discourse-cdn.com/v4/letter/j/ecd19e/32.png) [@jonathan.greene](https://forum.inductiveautomation.com/u/jonathan.greene)\
**Post date:** [June 17, 2019, 3:06pm UTC](https://forum.inductiveautomation.com/t/index-column-doesnt-increment/25868/3 "2019-06-17T15:06:57Z")

</div>

Thanks!