db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: DROP NOT NULL constraint
Date Thu, 23 Feb 2006 22:47:53 GMT
Derby doesn't allow droping NOT NULL constraint. That would be useful,
though DROP COLUMN that you really seem to want can be added to Derby
easily.

You could define your NOT NULL column to have a default... In that case,
you can stop specifying a value to those columns.

Satheesh

Piotr Bzdyl wrote:

> Hello,
>
> I found out that it is impossible to drop a column in a table in
> derby. I thought that I can live with that if I could drop not null
> constraint from the column I need to drop and leave that column unused.
>
> But: how can I drop not null constraint on the column?
>
> Best regards,
> Piotr
>
>
>


Mime
View raw message