Skip to main content
July 17, 2025
Solved

Impact on modifying deployed table data.

  • July 17, 2025
  • 8 replies
  • 0 views

We have deployed a table to higher environment  and used in required objects to perform operations, we want t o add 2 columns to it . How can we achieve this , also will there be any impact on the objects as its already in higher environments .

Best answer by stefanhelzle0001

Only adding a field does not impact any object using this table. But, as long as the other objects are not updated, they will not populate the new fields.

8 replies

stefanhelzle0001
July 17, 2025

I do not understand what your actual question is. Please explain your ask in more detail.

July 17, 2025

- I want to add new columns to a DB table which is already deployed to Production and being used in different places of our Application . If we alter the table and redeploy .How the objects which are already consuming it in production will affect .And how to handle it .

stefanhelzle0001
July 17, 2025

Only adding a field does not impact any object using this table. But, as long as the other objects are not updated, they will not populate the new fields.

harshas2775
July 17, 2025

You can make the changes but the things to keep in mind to scale efficiently is Active process instances will not have those 2 new fields. So ensure if any precedent rule of that process model should not reference those fields directly. Have default values setup in case the field can't be indexed for such cases.

Any rule or process you are modifying referencing these new columns, keep in mind not all instances will have those fields so don't use dot operators, user property() functions to reference those to avoid the ' cannot index field error ' in production 

July 17, 2025

Thanks you 

shubhama926776
July 17, 2025

Adding new columns to an existing production database table has no impact on objects currently using that table - all existing processes, interfaces, and reports continue working normally since they only reference their original columns. The new columns will remain empty until you explicitly update objects to populate them.

To handle this safely, make the new columns nullable, update your record type, and deploy through standard(Dev-Test-Prod) environments. You can then gradually update objects to use the new columns as needed - this is low-risk since you’re adding, not modifying existing structure.​​​​​​​​​​​​​​​​

July 17, 2025

Thanks you