getColumnLabel vs. getColumnName

Question

Label: Gets the designated column's suggested title for use in printouts and displays.

Name: Get the designated column's name.

Does anyone know how Label is determined?

score 43 · Accepted Answer · edited Oct 08 '18 at 10:28

43

String getColumnLabel(int column) throws SQLException;

If a SQL AS is not specified, the value returned from getColumnLabel will be the same as the value returned by the getColumnName method.

Example:

select id as user_no from users

edited Oct 08 '18 at 10:28

Morgoth

answered Nov 24 '10 at 20:30

stacker

2

I am getting user_no for getColumnLabel as well as getColumnName – Ajmal Khan Oct 12 '18 at 13:32
@AjmalKhan Same here, at least with the MySQL driver – isapir Jun 30 '19 at 03:52
I am getting same name in both , using DB2 JCC driver as well. Any idea please ? – rinilnath Feb 20 '20 at 12:43
getColumnName does not return what you say, not sure why. – mjs Feb 27 '23 at 15:32

1 Answers1