View Single Post
  #1 (permalink)  
Old 10-09-09, 10:05
andrewhallam andrewhallam is offline
Registered User
 
Join Date: Dec 2003
Location: Nottingham, England
Posts: 52
Dropping a default column value

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
Reply With Quote