Get information of Mysql table's structure in Java

Question

I am doing a project and I need to find some information of any given table of mysql. I need names of columns and their attributes such if any of them is index or not. I'm doing this in Java, how can I get this piece of info about any table?

thanks

score 1 · Accepted Answer · edited May 23 '17 at 12:13

1

Using JDBC, you can get that with:

String tableNamePattern = "customer";
DatabaseMetaData databaseMetaData = conn.getMetaData();

ResultSet columns = 
       databaseMetaData.getColumns(null, null, tableNamePattern, null);

ResultSet primaryKeys = 
       databaseMetaData.getPrimaryKeys(null, null, tableNamePattern);

ResultSet indexInfo = 
       databaseMetaData.getIndexInfo(null, null, tableNamePattern, false, false);

You can see the information, e.g. using Most simple code to populate JTable from ResultSet.

edited May 23 '17 at 12:13

Community

1
1

answered Nov 08 '13 at 05:55

Paul Vargas

40,346
15
98
144

Thank you to answer me but how about attributes? – Mossen Nov 08 '13 at 06:01
Ok ... I think i've got my answer :) – Mossen Nov 08 '13 at 06:03

score 0 · Answer 2 · answered Nov 08 '13 at 08:12

0

I think it's good as an example: http://www.herongyang.com/JDBC/sqljdbc-jar-Column-List.html

answered Nov 08 '13 at 08:12

Mossen

484
4
16

Get information of Mysql table's structure in Java

2 Answers2