Example Depot

try { // Create a result set Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM my_table"); // Get result set meta data ResultSetMetaData rsmd = rs.getMetaData(); int numColumns = rsmd.getColumnCount(); // Get the column names; column indices start from 1 for (int i=1; i<numColumns+1; i++) { String columnName = rsmd.getColumnName(i); // Get the name of the column's table name String tableName = rsmd.getTableName(i); } } catch (SQLException e) { }