I've figured out how to add and delete columns, but not how to alter them. I know there's an "alter column", but the syntax doesn't give a place to put what you're altering it to.

I want to do two things:

1. Change the type of a field
2. Change the name of a field

I'd like to do both of these without changing the values in the fields. Obviously, I can't go changing a float to an integer without hurting anything, but I'd like to be able to change a numeric 9.2 to a currency.

Thanks,

-Michelle