Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

IF EXISTS not recognized in Derby

Tags:

netbeans

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.

like image 737
Jag Avatar asked Dec 20 '22 00:12

Jag


1 Answers

Derby does not currently support IF EXISTS

like image 147
greg-449 Avatar answered Jan 06 '23 19:01

greg-449