On 2016-03-11 13:27, Arno Brinkman wrote:
> Hi All,
>
> According to the Firebird 3.0 releases notes i should be able to
> alter a
> column to not nullable.
>
> But when executing this script:
>
> CREATE TABLE TESTNULLABLE (ID INT);
> COMMIT;
>
> ALTER TABLE TESTNULLABLE ALTER ID NOT NULL;
> COMMIT;
>
> I get "Dynamic SQL Error SQL error code = -104 Token unknown - line
> 1,
> column 35 NOT"
You forgot the token SET, from page 67 (PDF page 77):
ALTER TABLE <table name> ALTER <field name> { DROP | SET } [NOT] NULL
Mark
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
