Detecting if a table in a database already exists ?

T

Thorsten Meininger

Sorry for this newbie question:
How do I find out from a java source if a table in a database already exists?

I cannot believe that I have to execute a SELECT statement and if there is an exception
I know that the table does not exist. But this is a really inconvenient solution.
There must be a direct request statement.

Thorsten
 
S

Sudsy

Thorsten said:
Sorry for this newbie question:
How do I find out from a java source if a table in a database already exists?

I cannot believe that I have to execute a SELECT statement and if there is an exception
I know that the table does not exist. But this is a really inconvenient solution.
There must be a direct request statement.

Thorsten

You're looking for java.sql.DatabaseMetaData. Obtain it via
java.sql.Connection#getMetaData. It's javadocs time!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top