I have deleted the number field now how i can regain that into my custom table

[navitharedd]

I have deleted the number field now how i can regain that into my custom table

[Bhargavi Patel]

@navitharedd 
If you deleted the Number field from a custom table, you can recreate it by adding a new field of type String with the column name number, then configure Auto Number on the table (System Definition → Tables) by specifying the desired prefix and number format. If the field was only removed from the form or list layout, simply add it back through Configure → Form Layout or List Layout.

[glideFather]

ahoy @navitharedd,

Option 1. 

navigate to the Deleted records module:

Locate your deleted record (either by user, by table name, by sys_id, by approximate time you deleted it, ...) and when you open it, there's an option to undelete it.

Similar to this:

Go to particular update set with the deleted record to find the sys ID if needed and use it for locating the deleted record in the deleted records module as seen above.

Option 2.

Export that field from other environment (ensure the sys ID matches), if it is OOTB you can move it from a PDI if it is custom then from other environment (e.g. move that field from TEST to DEV in case it was deleted in DEV).

[Ehab Pilloor]

@navitharedd,

If you have deleted it recently, you can find the record in System Definitions > Deleted Records. You can open the record and undelete it via UI Action.

If its OOB field and its you cant find it in above mentioned module, You can get the XML of the sys_dictionary record of that field and import it in the sys_dictionary table.

Please Accept this response as Solution if it assisted you with your question & Mark this response as Helpful.

Kind Regards,

Ehab Pilloor

[yashkamde]

Hello @navitharedd ,

yes, my answer is the same as above !

Also Refer this for detailed understanding :

Use the Deleted Records module to restore a deleted record 

If my response helped mark as helpful and accept the solution.