Java tutorial
import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.ResultSet; public class Main { private static final String DRIVER = "com.mysql.jdbc.Driver"; private static final String URL = "jdbc:mysql://localhost/yourDatabase"; private static final String USERNAME = "root"; private static final String PASSWORD = ""; public static void main(String[] args) throws Exception { ResultSet resultSet = null; Class.forName(DRIVER); Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD); DatabaseMetaData metadata = connection.getMetaData(); resultSet = metadata.getTypeInfo(); while (resultSet.next()) { String typeName = resultSet.getString("TYPE_NAME"); System.out.println("Type Name = " + typeName); } resultSet.close(); connection.close(); } }