Search code examples
netbeansderby

IF EXISTS not recognized in Derby


DROP TABLE IF EXISTS Pose ;

results in the error

Error code -1, SQL state 42X01: Syntax error: Encountered "EXISTS" at line 1, column 15. 

I'm running this from inside NetBeans 7.3 using the default Derby sample db.


Solution

  • Derby does not currently support IF EXISTS