Updating Table backend name

ArpitB207098286
Tera Contributor

I'm trying to update the backend name of the table of a scoped application via xml, it is getting updated but the label also gets updated showing 'label' only.

Is there any other way to updated the table backend name?

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @ArpitB207098286 

 

i prefer not to do this via XML, if it is just a start better create a new table and use it.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

GlideFather
Tera Patron

Hi @ArpitB207098286,

I think it is not good idea to change a table's name, I was actually thinking that was not possible to do...

To avoid future problems, delete the table with an incorrect name and create a new instead.

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


Bert_c1
Kilo Patron

It is only possible by creating a Support Case. The appropriate Support Team can do it from the database, lots of records to update to prevent data loss. Why is the changing the table name required when user see the table's Label?

 

Export the data, delete the table, then re-create it, and try importing the records. However you will need to edit each record's XML to change the name value before importing.

 

I see what you show when there is no Collection record for the table. (sys_dictionary record for the table with column_name empty). Seems a problem with the table creation.

Ankur Bawiskar
Tera Patron
Tera Patron

@ArpitB207098286 

what's the purpose to play with XML for changing the fields on table?

why not capture that in update set and migrate that update set?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader