[SQL] Change type of column

[Volker Paul]

Hello,

how can I change the type of a column, e.g. from varchar() to text?
Or is it possible to drop (i.e. delete) a column without
creating a new table from the old one but without that column,
dropping the old table and renaming the old to the new?

Thanks,

Volker Paul