You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Amir Michail <am...@gmail.com> on 2007/02/18 15:18:52 UTC

changing not null to null

Hi,

Is there an easy way to change a not null column to a null one?

Amir

Re: changing not null to null

Posted by Dan Scott <de...@gmail.com>.

Yep.

10.2 reference documentation is at http://db.apache.org/derby/docs/10.2/ref/

ALTER TABLE tableName ALTER COLUMN columnName NULL

... is described in the ALTER TABLE statement:
http://db.apache.org/derby/docs/10.2/ref/rrefsqlj81859.html

Dan Scott

On 18/02/07, Amir Michail <am...@gmail.com> wrote:
> Hi,
>
> Is there an easy way to change a not null column to a null one?
>
> Amir
>