db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Dohman <brdoh...@eiu.edu>
Subject Re: how to remove a column
Date Fri, 07 Sep 2007 15:55:58 GMT
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
>>
>>
>
>


Mime
View raw message