import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class MySQLJDBCSample { public static void main(String[] args) { System.out.println("Start TestMetaDataGet...\n"); Connection conn = null; Statement stmt = null; try { conn = DriverManager.getConnection("jdbc:mysql:///", "", ""); DatabaseMetaData dbMetaData = conn.getMetaData(); System.out.println("------------------------------------------------------------------"); System.out.println("DB version is " + conn.getMetaData().getDatabaseProductVersion()); System.out.println("DB product name= " + conn.getMetaData().getDatabaseProductName()); System.out.println("Connection obtained with Driver version= " + conn.getMetaData().getDriverVersion()); System.out.println("------------------------------------------------------------------"); ResultSet rsColumns = dbMetaData.getColumns(null, "my\\_schema", "newtable", "%"); while (rsColumns.next()) { System.out.println("Table Exist in Schema :"+rsColumns.getString(1)); } } catch (Exception e) { e.printStackTrace(); } } }