>I need to be able to alter field names in an existing table populated with
>data. It appears that ALTER TABLE ALTER COLUMN will permit you do anything
>except that.

You were close: try ALTER TABLE RENAME COLUMN myOldCol TO myNewCol. Just remember to update your indexes, relations, etc. as necessary.