Create an alias

You can create an alias for a table or view or for a member of a table or view. To view the SQL used to create this object, click Show SQL.

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Right-click the Aliases container and select New, then Alias.
  5. In the Alias name field of the Alias definition dialog, specify a name for the alias you are creating. The name cannot be the same as any index, table, view, file, or alias that already exists on the system.
  6. In the Alias schema field, specify the schema where the alias will reside.
  7. In the Referenced object name field, select the table or view that you want to create an alias for. To select a table or view from a different schema, change the schema name in the Referenced object schema field.
  8. To create an alias for a table partition, select the partition from the Referenced object partition field.
  9. In the Text field, specify a description of the new alias. This description can be up to 50 characters long. This field is optional.
  10. Click OK to create the alias.

Tip: You can also create an alias by right-clicking on a table or view, the All objects container, or a schema object and selecting New, then Alias.