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 (athena.apache.org: domain of peter.ondruska@gmail.com
 designates 66.249.92.173 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:mime-version:in-reply-to:references:content-type:message-id:content-transfer-encoding:subject:date:to:x-mailer:from;
        b=jLlFUiHKQzY41t9x3ZMDgg5gwYsF7ZLaaCj8c86WNjrBgwMtEwiOf4L4cH3Kzae/ojxTyxL7b7US457xSeJTp5XMKpGstE8J+yEtwwFLBdqhn1q+2HcIhbcf9+ecCWwvoE7pucm9yYPA2amIqH8YhkwfcWomUclvWNuS2x3orFU=
Mime-Version: 1.0 (Apple Message framework v752.3)
In-Reply-To: <46E1772A.3040201@eiu.edu>
References: <46E16F7F.5070405@eiu.edu> <46E156B3.9030807@sun.com>
 <46E1748E.8050308@eiu.edu> <fbrlk8$tho$2@sea.gmane.org>
 <46E1772A.3040201@eiu.edu>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <17C4D4AB-D623-43EC-B891-0BACC4DDBF0E@gmail.com>
Content-Transfer-Encoding: 7bit
Subject: Re: how to remove a column
Date: Fri, 7 Sep 2007 16:11:56 +0200
To: "Derby Discussion" <derby-user@db.apache.org>
From: Peter Ondruska <peter.ondruska@gmail.com>

Create another table without the column you want to drop and insert  
data from old table.

On 7.9.2007, at 18:07, Brandon Dohman wrote:

> Is it possible to remove a column any other way?  Without using the  
> drop command?
>
> Tim Dudgeon wrote:
>> 10.3 is the first released version to support DROP COLUMN.
>> Prior to 10.3 this was not possible.
>>
>> Tim
>>
>> Brandon Dohman wrote:
>>> Rick
>>>
>>> Yes I am using the older version, not sure which version, but I  
>>> haven't updated it since January of this year.  Due to time  
>>> constraints i would prefer not to update at this time.  Unless it  
>>> can't be avoided to drop a column that I need dropped.
>>>
>>> Thanks for your help
>>>
>>> Rick Hillegas wrote:
>>>> Hi Brandon,
>>>>
>>>> This syntax works in the latest Derby release (10.3.1.4). Are  
>>>> you using an older version of Derby?
>>>>
>>>> Thanks,
>>>> -Rick
>>>>
>>>> Brandon Dohman wrote:
>>>>> I was wondering what the sql syntax is to drop a column from a  
>>>>> derby database.
>>>>>
>>>>> i tried this and it gave me the error below: ALTER TABLE  
>>>>> contacts DROP COLUMN userid
>>>>>
>>>>> Error code -1, SQL state 42X01: Syntax error: Encountered  
>>>>> "DROP" at line 1, column 22.
>>>>> Line 1, column 1
>>>>>
>>>>> Thanks for your help
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
> -- 
>
> Brandon Dohman
> Chief Technical Officer
> Mobile Medical Systems
> 2612 DeWitt Av
> Mattoon, IL 61938
> 815.383.6909
>
> www.mobilemedicalsystems.com
> www.pen.eiu.edu/~brdohman
>