IBM Informix Dynamic Server Version 11.10.UC1
Could someone please confirm to me that the only way to drop a default column value in Informix is to basically alter the column to itself minus the default - for example.
Add the default:
ALTER TABLE mytab MODIFY mycol varchar(10) default 'x'
Remove the default:
ALTER TABLE mytab MODIFY mycol varchar(10)
i.e there is no equivalent command to DB2's
ALTER TABLE mytab ALTER COLUMN mycol DROP DEFAULT
thanks for any replies to this.
Andy