Hi;

Try this:

update RDB$RELATION_FIELDS set
RDB$NULL_FLAG = 1
where (RDB$FIELD_NAME = 'MY_FIELD') and
(RDB$RELATION_NAME = 'MY_TABLE')

hope this help you!

----- Original Message -----
From: "Lourenço de Paula" <lourenco.d@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, August 28, 2003 3:23 PM
Subject: [firebird-support] nullable to not null



Hello,

I'm trying to alter a column from nullable to not null, I'm using the
following command:

ALTER TABLE MY_TABLE alter MY_FIELD TYPE NUMERIC(5,2) NOT NULL

but firebird is showing a error message.

How can I alter a column from nullable to not null???

Any help will be usefull.

Thanks

Lurenço de Paula
lourenco.d@...

[Non-text portions of this message have been removed]



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/