You can't. Create a new field

MY_NOTNULL_FIELD NUMERIC(5,2) DEFAULT 0 NOT NULL



Lourenço de Paula wrote:

>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/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus