# Can I add extra columns to sqlt\_core?

**URL:** <https://forum.inductiveautomation.com/t/can-i-add-extra-columns-to-sqlt-core/1854>\
**Category:** Ignition\
**Created:** [May 18, 2010, 10:21pm UTC](https://forum.inductiveautomation.com/t/can-i-add-extra-columns-to-sqlt-core/1854 "2010-05-18T22:21:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [May 18, 2010, 10:21pm UTC](https://forum.inductiveautomation.com/t/can-i-add-extra-columns-to-sqlt-core/1854/1 "2010-05-18T22:21:22Z")

</div>

I’m trying to find ways to improve performance of my app and one of the bottlenecks is searching the sqlt\_core table to find the right row to update. I’m wondering if I can add a foreign\_key column without messing up the works.

I have a few other things to try first.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [May 18, 2010, 11:32pm UTC](https://forum.inductiveautomation.com/t/can-i-add-extra-columns-to-sqlt-core/1854/2 "2010-05-18T23:32:35Z")

</div>

You can certainly add a foreign key without messing up the application. You can alter the table however as long as you don’t change column names or data types. Adding columns, indexes, foreign key, etc is ok.