import java.sql.*; public class test_80473 { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/"; String dbName = "sakila"; String driver = "com.mysql.jdbc.Driver"; String userName = "root"; String password = "chiran"; try { Class.forName(driver).newInstance(); Connection conn = DriverManager.getConnection(url+dbName,userName,password); DatabaseMetaData md = conn.getMetaData(); ResultSet res = md.getTables(null, null, "%", null); System.out.println("List of tables: "); 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") + ", "+res.getString(5)); } conn.close(); } catch (Exception e) { e.printStackTrace(); } } }