Re: SQL Query - Alter table for default values.

From: "Stephens, Alan" <alans@credo.ie> > >Informix Dynamic Server 7.2 on solaris > >What is the sql syntax for changing the default value on an existing >field in a table. > >e..g in table x field z was given a default of ' ' (blank space) on >creation >but now want to alter the table so it has a default of '0' At a guess, I'd say you have drop the old constraint and add a new one. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com