Example 1: Create an alias named CURRENT_PROJECTS for the PROJECT table.
CREATE ALIAS CURRENT_PROJECTS FOR PROJECT
Example 2: Create an alias named SALES_JANUARY on the JANUARY partition of the SALES table. The sales table has 12 partitions (one for each month of the year).
CREATE ALIAS SALES_JANUARY FOR SALES(JANUARY)
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.