Manas BHardwaj solution will work, but it deletes the column from the database as well as the values it contains. So if any of your other software uses that column, it will fail when it tries to access it.
It may be that you want to get rid of the values in the column only: that's also pretty simple.
Assuming the column is NVARCHAR:
UPDATE myTable SET MyColumn=''
Will remove all the values.
If the column is NULLABLE, then:
UPDATE myTable SET MyColumn=NULL
Is a better solution.