How can I ALTER the DEFAULT value of a column which is pre-defined? Without dropping it.

Ex:

ALTER TABLE MEMBER ALTER COLUMN MEMBER_TYP
TYPE
VARCHAR (10) CHARACTER SET WIN1254 DEFAULT 'E';

this statement is not working

Regards,

[Non-text portions of this message have been removed]