Hi,

> How can I ALTER the DEFAULT value of a column which is pre-defined?

Without dropping it.

You can't.

> Ex:
>
> ALTER TABLE MEMBER ALTER COLUMN MEMBER_TYP
> TYPE
> VARCHAR (10) CHARACTER SET WIN1254 DEFAULT 'E';
>
> this statement is not working

There are workarounds:

1) define a DOMAIN and modify the column type to the domain

2) use Database Workbench and edit the default in the Table Editor -> check
the "DDL" tab to see how it's done. This is also a workaround, and it
updates the system tables directly.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com