db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wolf Bublitz <wolf.bubl...@uni-dortmund.de>
Subject checking if table exists
Date Wed, 03 Oct 2007 12:18:42 GMT
Hi,

I'm new to Derby DB and I want to know how it is possible to check if  
a table exits. Via the command line tool I can get a list by typing  
"SHOW TALBES" but in Netbeans' db-editor  this does not work.

I get the following error:

SHOW TABLES

Error code 30000, SQL state 42X01: Syntaxfehler: Encountered "SHOW"  
at line 1, column 1.
Line 1, column 1


Greetings Wolf

Mime
View raw message