ALTER TABLE Pages DROP COLUMN Links
Exception in thread "main" java.sql.SQLSyntaxErrorException: Syntax
error: Encountered "DROP" at line 1, column 19.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at
org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.Statement.execute(Unknown
Source)
at linkcounter.Main.main(Main.java:14)
Caused by: org.apache.derby.client.am.SqlException: Syntax error:
Encountered "DROP" at line 1, column 19.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown
Source)
at
org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown
Source)
at
org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown
Source)
at
org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown
Source)
at
org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown
Source)
at
org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown
Source)
at
org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown
Source)
at org.apache.derby.client.am.Statement.flowExecute(Unknown
Source)
at org.apache.derby.client.am.Statement.executeX(Unknown
Source)
... 2 more
Java Result: 1
You can't drop column.
See syntax here:
http://db.apache.org/derby/docs/10.1/ref/
My, that is a significant variance from the SQL standard.
I found a more complete comparison of Derby syntax with SQL 92 at
<http://publib.boulder.ibm.com/infocenter/cscv/v10r1/index.jsp?topic=/com.ibm.cloudscape.doc/rrefsql9241891.html>
--
Lew