question Restoring deleted column in Developer forum

Restoring deleted column

nowbeliever — Wed, 29 Mar 2017 14:12:41 GMT

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) ?

Re: Restoring deleted column

Anurag Tripathi — Wed, 29 Mar 2017 14:58:20 GMT

Hi Thomas,

You can get the column back by navigating to 'Deleted Records' but i guess data is gone, you wont get that data back.

Re: Restoring deleted column

nowbeliever — Wed, 29 Mar 2017 15:40:16 GMT

Thank you, Anurag. I navigated to system Definition --> Deleted Records and I couldn't find u_ticket_classification ?

Is there anywhere else I might find it?

In the deleted records, I can see "report stats executions" and "report executions" listed under table name column for today. If I group it by table, and looked under incident table, that column u_ticket_classification is still not there.

Any idea ?

Thank you for your help.

Re: Restoring deleted column

Anurag Tripathi — Wed, 29 Mar 2017 15:56:02 GMT

I just tried the same in my personal instace too. Even though 'Audit' is turned on i am still not finding the dictionary i deleted in deleted records, this is weird.

Ill do some more research on this and come back if i finds something useful.

Re: Restoring deleted column

Deepak Ingale1 — Wed, 29 Mar 2017 17:09:52 GMT

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

Re: Restoring deleted column

nowbeliever — Wed, 29 Mar 2017 19:19:44 GMT

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.

Re: Restoring deleted column

Mansha — Tue, 10 Sep 2019 07:42:41 GMT

Hi Deepak,

Somehow i deleted the record form "sys_metadata_delete" as well. So, Is there any option to get it back now ?