How to detect a SQL table s existence in Java

Question

How can I detect if a certain table exists in a given SQL database in Java?

Answer 1

Hello,

Depending on the DB, you can do (MySQL)

SHOW TABLES

or (Oracle)

SELECT * FROM user_objects WHERE object_type = 'TABLE'

or 

another thing for SQL Server. 

Cycle through the results for MySQL or further filter on the Oracle one.

Hope this help!!