- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2017 07:12 AM
I accidentally deleted a column (u_ticket_classification) in the Incident table, Is there anyway, that column can be restored without losing everything (rows of records) ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2017 10:09 AM
sys_metadata_delete is the table you need to consider to restore deleted column. Delete records are placeholder for 'deleted records' whereas sys_metadata_delete is placeholder
I had done that once in past, and along with column, it stored column value as well .
Again, i would suggest to experiment this in sub prod before performing on PROD
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-29-2017 12:19 PM
Deepak,
I tested it out on the sandbox and it worked. I, then, went back to the PROD box and restored the column back to the original status including the deleted UI policies that associates with it. My ServiceNow is back in business.
sys_metadata_delete table is the key to restore all accidentally deleted column(s) and related records.
Thank you again, Deepak and Anurag.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-10-2019 12:42 AM
Hi Deepak,
Somehow i deleted the record form "sys_metadata_delete" as well. So, Is there any option to get it back now ?
