> -----Original Message-----
> From: dianeb77@... [mailto:dianeb77@...]
> Sent: Jueves 1 de Marzo de 2001 23:30
>
> --- In IBDI@y..., "Claudio Valderrama C." <cvalde@u...> wrote:>
> > And what happens with NULL v/s not NULL? I've seen people
> complaining for this.
>
> Ummm, what is the context?
>
> The SQL standard says that, by default, all columns allow nulls,
> unless there is a NOT NULL column constraint or equivalent. There is
> no specific syntax in SQL92 that you can use to indicate that nulls
> are welcome in a particular column ...

We are compliant, we are compliant, we are... :-)
I admit my question was twofold: what happens then once a column was
defined, is there any syntax to change the NULL/NOT NULL state of such
column?

C.