How to delete custom column using fix script?

kevinharalson
Mega Expert

Is there a way to script a column's deletion so that everything is performed as though the column was deleted using the GUI?

The London release has introduced a "Parent Contract" field to the ast_contract which has resulted in our custom "Parent Contract" field added in early 2017 to be redundant. I am working on a fix script to copy the data from the custom field into the OOB field, and would like to be able to delete the custom column as the final step in the script.

 

9 REPLIES 9

sachin_namjoshi
Kilo Patron
Kilo Patron

 

After you copy data from custom field to OOB field, you don't to write fix script to delete column.

You can just go to system dictionary to delete custom column.

 

find_real_file.png

Regards,

Sachin

Is there a way to delete the column using a fix script so that everything is in one place?

Coleton
Kilo Guru

You'll need to run a fix script/background script to copy the existing field data into the OOTB London field. Once you have, you can simply delete the column from the table and it will drop the data.

Prateek kumar
Mega Sage

May i know why are you looking for a script if you can do it with a Click of a Button.


Please mark my response as correct and helpful if it helped solved your question.
-Thanks