Restoring deleted column

[nowbeliever]

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

[Anurag Tripathi]

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.

[nowbeliever]

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.

[Anurag Tripathi]

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.

[Deepak Ingale1 · Accepted solution]

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