The CREATE ALIAS statement creates an alias on a table, view, or member of a database file.
Create an alias named CURRENT_PROJECTS for the PROJECT table.
CREATE ALIAS CURRENT_PROJECTS FOR PROJECT
To create an alias named SALES_JANUARY for member JANUARY of the SALES table.
CREATE ALIAS SALES_JANUARY FOR SALES(JANUARY)
For more information, see CREATE ALIAS in the SQL Reference topic in the
Information Center.