Why do you need to delete it. Why not just remove  it from the view by goin
to the Modiufy setting and columns for the List/Document Library in
question and edit the view and uncheck the columns that you don't want to
show.

Well i dont want to delete the column  but
all i want is to remove  the hyperlink  and leave only the name. Because
the hyperlink leads to the relevant user  information and i want to
limit that action by only displaying the created  by user's name. Hope
this sounds clear....