>Is there a way of altering the NAME of a field using ALTER TABLE?
>If not, how can I do it programmatically?

The RENAME COLUMN clause of ALTER TABLE. Its in the documentaiont, it towards the bottom of the 3rd variation of teh command, thats probably why you missed it.