# How to add one more colum?

**URL:** <https://forum.inductiveautomation.com/t/how-to-add-one-more-colum/64289>\
**Category:** Ignition\
**Tags:** namedqueries, database, scripting\
**Created:** [September 20, 2022, 3:43pm UTC](https://forum.inductiveautomation.com/t/how-to-add-one-more-colum/64289 "2022-09-20T15:43:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raj\_Bhatt](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@Raj\_Bhatt](https://forum.inductiveautomation.com/u/Raj_Bhatt)\
**Post date:** [September 20, 2022, 3:43pm UTC](https://forum.inductiveautomation.com/t/how-to-add-one-more-colum/64289/1 "2022-09-20T15:43:13Z")

</div>

![Databaseq](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/7/b79e5eec48867f1240d639d41024d5a017ce84fc.png)

Hello everyone, how can i add one more column called “delivery date” on this existing table?

Please help,

Thank you very much

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [September 20, 2022, 4:02pm UTC](https://forum.inductiveautomation.com/t/how-to-add-one-more-colum/64289/2 "2022-09-20T16:02:18Z")

</div>

You need to do this in to your database, not via Ignition (though you may be able to run an alter table with a system.db.runUpdateStatement - never tried).

In your SQL Workbench you’d write sometthing like `ALTER TABLE joblist ADD COLUMN devlivery_date datetime;` Some syntax may change depending on your particular SQL flavor and what constraints you want.