getColumnLabel vs. getColumnName

Question

What is the difference between ResultSetMetaData.getColumnLabel and ResultSetMetaData.getColumnName?

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?

Answer 1

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 

• getColumnLabel would return 'user_no'
• getColumnName would return 'id'