How to delete a particular column data completely in the list of table?

[mallikarjunared]

I am able to delete data for a column following each and every row of that column one by one. If I want to delete the complete data for a particular column, I am not able to do it.

But I can update the empty column completely by dragging mouse with control key for that particular column.

Please suggest me how to delete it.

[pradeepgupta]

Hi Mallikarjuna,

ACL might be written on the field who is restricting to delete the data.

[Subhajit1]

You can do this by running Background Scripts:-

Lets say that the table is u_table and column is u_column.

var gr = new GlideRecord('u_table');

gr.query();

while(gr.next())

{

gr.u_column='';

gr.update();

}

If there are too many records, you might do this in phases using the setLimit function

[Anurag Tripathi]

A very simple way will be,

Go to that dictionary entry, change its type . this deletes all the existing data of the column from all the records. Now change back the type to original

[Vance1]

Changing the type is not working