How to change table name.

archanajoshi
Kilo Expert

Hi All,

I need to change table.

find_real_file.png

I have tried though elevated role "Security_admin" but no luck.

Please help.

Thanks,

Archana Joshi.

7 REPLIES 7

Anurag Tripathi
Mega Patron
Mega Patron

Long shot, but if its worth enough for you to take this much pain then here is a way by which you can create a new table(with the new name) and copy all columns form the existing table to the new one(data preserved)



Promote a Field from an Extended Table in ServiceNow - ServiceNow Guru


-Anurag

maer2704
Tera Contributor

Hi, at this time there is no way for modify the table name due all the relations created when you create a table, the best   I think would be delete the table   if you can and recreate it with all the columns like Anurag said.



Good luck!!!


Tim Grindlay
Kilo Sage

FWIW, anyone reading this I've just tried the following:

- Closed my update set, and exported it to xml

- Backed out the update set (Ignored errors)

- Opened the update set in notepad++

- Used find and replace to replace all occurrences of the wrong table name with the new one.

- Saved a copy of the update set

- Imported and previewed the new update set

- Accepted all remote updates for problems found

- Commit 

So far it appears to have worked.