Subject Re: alter table syntax
Author skotaylor
--- In, "Martijn Tonies"
<m.tonies@u...> wrote:
> Hi,
> > I'm want to alter a column from 'NOT NULL' to 'NULL', it doesn't need
> > to be 'NOT NULL' it's not part of any constraints.
> well, it's pretty clear - you cannot do this. :-)

About as clear as mud.

> In order to do that, you need to drop a constraint and set the
> RDB$NULL_FLAG column.

Thanks, there is is.

First have to close all connections to the database, then:

update RDB$Relation_Fields set RDB$Null_Flag = null
where RDB$Field_Name = 'NAME'
and RDB$Relation_Name = 'STMENU'

That seems to have worked fine.

Thanks for the hint.

> An easier way is to download yourself a trial of Database Workbench
> ( ) - start the Table Editor and uncheck the "not
> null" box, then press "Save".

Nice, and I'm lazy, but not that lazy. I like to know how to do
things. ;)

> With regards,