db-derby-user mailing list archives

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
>
>