How do I know the designated column’s table name?

package org.kodejava.example.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

public class TableNameExample {
    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private static final String URL = "jdbc:mysql://localhost/testdb";
    private static final String USERNAME = "root";
    private static final String PASSWORD = "";
    public static void main(String[] args) throws Exception {
	Connection connection = null;
	try {
	    connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
	    Statement statement = connection.createStatement();
	    String query = "SELECT, a.username, a.country_id, b.country_name "
	    		+ "FROM users a " 
	    		+ "LEFT JOIN countries b "
	    		+ "ON a.country_id =";
	    ResultSet resultSet = statement.executeQuery(query);
	    // Here we have a query that use multiple table, we then want to 
	    // know to which table a column is belong to. In the ResultSetMetaData
	    // there is a getTableName() method that can do this functionality.
	    ResultSetMetaData metadata = resultSet.getMetaData();
	    String tableName = metadata.getTableName(1);
	    System.out.println("Table name of column 'id' = " + tableName);
	    tableName = metadata.getTableName(4);
	    System.out.println("Table name of column 'country name' = " + tableName);	    
	} catch (SQLException e) {
	} finally {

Wayan Saryada

Founder at Kode Java Org
I am a programmer, a runner, a recreational diver, currently live in the island of Bali, Indonesia. Mostly programming in Java, Spring Framework, Hibernate / JPA. You can support my works by donating here. Thank you.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.