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