Rename Columns in Query Results

The default heading for each column is the name given to the query results when it was created. You can rename a column heading for display purposes.

To rename a column heading, use one of these options instead of the column name in a select list:

This provides a substitute name for the column. For example, to change pub_name to “Publisher” in the previous query, type any of the following statements:

The results of any of these statements look like this:
Publisher                 pub_id 
----------------------    ------ 
New Age Books             0736 
Binnet & Hardley          0877 
Algodata Infosystems      1389 
 
(3 rows affected)