Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Mon, 07 Nov 2005 13:02:32 -0800
From: Rick Hillegas <Richard.Hillegas@Sun.COM>
Subject: Re: Drop column/change default.
In-reply-to: <3154.201.35.78.133.1131396060.squirrel@webmail.plugin.com.br>
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <436FC0E8.5090107@sun.com>
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
References: <3154.201.35.78.133.1131396060.squirrel@webmail.plugin.com.br>

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.

Cheers,
-Rick

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?
>
>
>Tkx,
>
>Edson Richter
>
>  
>