HELP: Field deletion/renaming

I am wondering if anyone has written a script/program (most likely in SQL) to delete or rename fields in a table? The requirements are that after running the script the table will still have all of its grants and the field in question will be deleted/renamed.

Thanks,
Chris

--
+-------------------+--------------------------------------------------------+


|  Chris Roberts    | Sleep, those little slice of death, how I loathe them. |


|  robertcj_at_tuns.ca |                                             -E.A. Poe  |


 +-------------------+--------------------------------------------------------+