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

Timoteo Ponce · Accepted Answer · 2012-03-07T05:43:29.647

4

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

edited Mar 07 '12 at 05:43

answered Mar 07 '12 at 05:23

Timoteo Ponce

510
9
27

score 3 · Answer 2 · edited May 23 '17 at 10:24

3

DatabaseMetaData will be useful for your requirement.

please also check nearly similar stackoverflow question

edited May 23 '17 at 10:24

Community

1
1

answered Mar 07 '12 at 05:31

Balaswamy Vaddeman

8,360
3
30
40

score 1 · Answer 3 · answered Mar 07 '12 at 05:24

1

use the DatabaseMetadata for get database related information. Database Metadata

answered Mar 07 '12 at 05:24

Rakesh Patel

393
2
10

Retrieving MYSQL Database structure information from Java

3 Answers3