Retrieving MYSQL Database structure information from Java

Question

I'm trying to do with java and mysql the same I am used to with .net and SQL server:

By using Microsoft.SqlServer.Management.Smo I can access database structure information from my instance ( server name, table structure, columns, datatype, description, default value)

I tried to find to do the same with Java + MYSQL but it seems it is not so popular

any directions?

thanks

Ed

Answer 1

The simplest way to accomplish it is by retrying the connection metadata, first you open a connection:

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "user","****");
DatabaseMetaData metaData = conn.getMetaData();

then start navigating through the metadata, you can check the available operations in DatabaseMedata