next up previous
Next: Tuple Variables Up: Basic Structure Previous: The from Clause

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, as loan_id

    from borrower, loan

    where = and bname= ``SFU"

Osmar Zaiane
Fri May 22 19:39:12 PDT 1998