Change default value 1

[rgbanse]

I have created and populated an informix table.
The schema has a default value for two of the fields.
I want to remove the default value. Is this possible without blowing away the table and re-populating?
Thx
RGB

 

[olded]

Hi:

Here's an example:

Given table:

create table x_stkrmlkup
(
stkrmid char(4) not null ,
sendtowm char(1) default 'N'
);

to drop the default, execute this, from dbaccess/isql:

alter table x_stkrmlkup modify sendtowm char(1)

Regards,


Ed

 

[rgbanse]

Thx Ed - exactly what I needed
RGB