CREATE ALIAS

The CREATE ALIAS statement creates an alias on a table, view, or member of a database file.

Example:

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 CenterLink to Information center.