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: how to remove a column
Date Fri, 07 Sep 2007 13:48:35 GMT
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