db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Drop column/change default.
Date Mon, 07 Nov 2005 21:02:32 GMT
Hi Edson,

Enhancement request 396 tracks this issue and Scott MacDonald is working 
on it. For current capabilities, see the ALTER TABLE section of the 
Reference Manual. In a nutshell, you can't drop a column.


edson.richter@mgrinformatica.com.br wrote:

>I have found no way to drop a column from a table. Is this possible?
>In meanwhile, if I can't drop the column, I need to change it from NOT NULL to NULL. AFAIK,
>this is not possible. So, I need to change the column to add DEFAULT 0 (since it's numeric,
>I just put a 0 in place).
>So, what is really possible to do? Drop column? Put a default?
>Edson Richter

View raw message