Add/Modify a field to a table in the Database | Community
Skip to main content
J
jasonw30638826
Level 3
August 21, 2018
Solved

Add/Modify a field to a table in the Database

  • August 21, 2018
  • 4 replies
  • 3462 views

Hi,

I am on the premise server for about 2 years now. I wonder if it's save now to add field(s) by going to Tools > Advanced > Add new fields. Will it cause any issue to the system functionality and stability?

Also how can I edit the exiting field name in a table?

Thanks,

Jason

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Garima_Gakhar

    Hi jasonw30638826

    Any changes to Schema ideally should be followed by the 'Update database structure' step.

    You are right, if the 'Yes' is highlighted under Synchronize (within the list of Schemas), it means indeed there was a change to the Schema and that needs to be updated. Complete the Update database structure Wizard and then log off from the Server, login again to view the added fields.

    In case no Schema show up as highlighted in that list, or simply if there is a "No" under Synchronize, Update database structure is not required.

    4 replies

    vraghav
    Adobe Employee
    vraghavAdobe Employee
    Adobe Employee
    August 22, 2018

    Hi jasonw30638826,

    The Add a field functionality is pretty mature and should not cause any issues, but then we don't know what you are trying to add and how many rows there are in the table.

    Adding a field will cause the DB structure to be updated, thus taking locks while doing so.

    If the table has millions of rows, it can cause issues. We

    will suggest that you take the system offline for external users, probably stop WFSERVER and MTA and then make the update.

    Regarding editing the existing field name, you need to go to schema and find the corresponding attribute, only to change the label or name as per your requirement.

    Then you should update the DB structure as well.

    Regards,
    vipul

      J
      jasonw30638826Author
      Level 3
      August 22, 2018

      Hi Vipul,

      Thanks so much for your reply. I'd like to confirm with you for the steps below before adding the fields.

      1. I will add about 5-10 date fields by going to Tools > Advanced > Add new fields
      2. Go to Configuration\Data sachems\Recipients(nms), then right click, click on regenerate selected schema
      3. Then go to Tools > Advanced > update database structure, then select Recipients(nms) to update the SQL to update the database structure
      4. Restart the application server

      Can I skip step 3 and step 4? From this page, New field wizard , I don't see step 3, update database structure is mentioned.

      When updating database structure is needed, will it be highlighted as the image shows below? If there is no highlight, does it mean no need to update database structure?

      d_ncs_integration_schema_update_select.png

      Thanks,

      Jason

      Garima_Gakhar
      Adobe Employee
      Garima_GakharAdobe EmployeeAccepted solution
      Adobe Employee
      August 22, 2018

      Hi jasonw30638826

      Any changes to Schema ideally should be followed by the 'Update database structure' step.

      You are right, if the 'Yes' is highlighted under Synchronize (within the list of Schemas), it means indeed there was a change to the Schema and that needs to be updated. Complete the Update database structure Wizard and then log off from the Server, login again to view the added fields.

      In case no Schema show up as highlighted in that list, or simply if there is a "No" under Synchronize, Update database structure is not required.

        J
        jasonw30638826Author
        Level 3
        August 22, 2018

        Thanks so much Garimag!

        Jason

        Terms & ConditionsAccessibility statement

        Loading footer...