db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Dohman <brdoh...@eiu.edu>
Subject how to remove a column
Date Fri, 07 Sep 2007 15:34:23 GMT
I was wondering what the sql syntax is to drop a column from a derby 

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

View raw message