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 3, SQL state 42X01:
it finds.
Not sure if this helps you though
- Original Message - From: Wolf Bublitz [EMAIL PROTECTED]
dortmund.de
To: derby-user@db.apache.org
Sent: Wednesday, October 03, 2007 2:18 PM
Subject: checking if table exists
Hi,
I'm new to Derby DB and I want to know how it is possible
That`s the way it should be, but does not work either.
String[] names = { TABLE };
ResultSet result = null;
DatabaseMetaData metadata = null;
try {
metadata = dbConnection.getMetaData();
result = metadata.getTables(null, null, null,
John Embretsen:
Wolf Bublitz wrote:
That`s the way it should be, but does not work either.
Make sure you are accessing the correct database and the correct
schema.
The location of the database you are connecting to may depend on
a) whether you are running embedded or client/server
b