How to check if a table exists using jdbc java

Question

How to check if a table exists using jdbc java

Navigation

#1 by (3 votes)

1

How to check if a table exists in jdbc using Sqlite3?

java

asked by anonymous 25.04.2016 / 02:25

1 answer

Print Variables in Ruby How to implement "foreign key" using Micro Services architecture? Django

score 3 · Answer 1

You can use the available metadata:

  DatabaseMetaData meta = con.getMetaData();
  ResultSet res = meta.getTables(null, null, "My_Table_Name", 
     new String[] {"TABLE"});
  while (res.next()) {
     System.out.println(
        "   "+res.getString("TABLE_CAT") 
       + ", "+res.getString("TABLE_SCHEM")
       + ", "+res.getString("TABLE_NAME")
       + ", "+res.getString("TABLE_TYPE")
       + ", "+res.getString("REMARKS")); 
  }

See more details here . Note the warnings at Javadoc .