How to add one more colum?

Raj_Bhatt · September 20, 2022, 3:43pm

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

Please help,

Thank you very much

bkarabinchak.psi · September 20, 2022, 4:02pm

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.