Find the constraint's auto-generated name in the system tables and use
alter table/drop constraint
to get rid of the NOT NULL.
Once you have removed it, YOU CANNOT INSERT IT AGAINST. There's no command
like
add constraint not null.
You would have to fiddle with system tables to set it to not null again.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing

""Stevio"" <redeagle@...> wrote in message
news:000901c12020$cc5eed20$5e1287d9@kg...

> Also, is there an easy way to alter this so that it is not NOT NULL?
>
> Thanks,
> Stephen
>
> > I have the following line declared in my Firebird database metadata:
> > DATE_ENTERED TIMESTAMP NOT NULL,
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>