db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Caine <step...@commongrnd.com>
Subject Re: checking if table exists
Date Wed, 03 Oct 2007 13:42:35 GMT

We include a Derby Manager with our Qilan v3.1 download.  It is web  
based and will allow most schema operations (including viewing  
tables) as well as data editing.  Qilan is shareware and can be  
downloaded from:


Good luck,

Stephen Caine
CommonGround Softworks, Inc.
> 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:
> Error code 30000, SQL state 42X01: Syntaxfehler: Encountered  
> "SHOW"  at line 1, column 1.
> Line 1, column 1
> Greetings Wolf

View raw message