The Rename Operation

1. Rename: a mechanism to rename both relations and attributes.
2. as-clause can appear in both the select and from clauses:

   old-name as new-name.

3. Example.

    select distinct cname, borrower.loan# as loan_id
   
   		 from borrower, loan
   
   		 where borrower.loan# = loan.loan# 
   and bname= ``SFU"