How can I detect a SQL table’s existence in Java?

by

You can use DatabaseMetaData.getTables() to get information about existing tables.

This method works transparently and is independent of the database engine. I think it queries information schema tables behind the scenes.

Edit:

Here is an example that prints all existing table names.

DatabaseMetaData md = connection.getMetaData();
ResultSet rs = md.getTables(null, null, "%", null);
while (rs.next()) {
  System.out.println(rs.getString(3));
}

More Related Contents:

  1. Can I have H2 autocreate a schema in an in-memory database?
  2. How to overcome the Permgen Space Exception Without restarting the Server.., Can any one help me
  3. Hibernate show real SQL [duplicate]
  4. How to get SQL from Hibernate Criteria API (*not* for logging)
  5. How can you call custom database functions with Hibernate?
  6. Is the IN relation in Cassandra bad for queries?
  7. How is driver class located in JDBC4
  8. Getting output from dbms_output.get_lines using JDBC
  9. Filling combobox from database by using hibernate in Java
  10. Ways to save enums in database
  11. Java – Can’t use ResultSet after connection close
  12. Timezones in SQL DATE vs java.sql.Date
  13. SQL prepared statement how to select via multiple possible menu selections?
  14. Room – Schema export directory is not provided to the annotation processor so we cannot export the schema
  15. Is there any good dynamic SQL builder library in Java? [closed]
  16. MyBatis Batch Insert/Update For Oracle
  17. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  18. What is the correct way to do inserts/updates/deletes in Android SQLiteDatabase using a query string?
  19. Save child objects automatically using JPA Hibernate
  20. JPA Native Query select and cast object
  21. Light weight alternative to Hibernate? [closed]
  22. JPA 2 CriteriaQuery, using a limit
  23. Hibernate, spring, JPS & isolation – custom isolation not supported
  24. How to listen for Firebase setValue completion
  25. HQL joined query to eager fetch a large number of relationships
  26. Hibernate Criteria API: get n random rows
  27. Is MERGE an atomic statement in SQL2008?
  28. Embedding mysql in java desktop application
  29. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  30. Does JPA support mapping to sql views?

Leave a Comment