GetColumnLabel vs getColumnName

Question

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

Label: Returns the title of the header assigned to the column for use in printouts and displays.

Name: Get the name of the assigned column.

Does anyone know how Label is defined?

Answer 1

String getColumnLabel(int column) throws SQLException; 

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

Example:

 select id as user_no from users 

• getColumnLabel will return 'user_no'
• getColumnName will return 'id'