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.

737

asked Dec 20 '22 00:12

Derby does not currently support IF EXISTS

147

answered Jan 06 '23 19:01

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!