Creating an alias

Use the Create Alias window to create an alias (alternate name) for an existing table or view, or for a table or view that you plan to create.

Fields and controls

Authorities and privileges



To create an alias for a table or view:

  1. Open the Create Alias window.
  2. Use the Alias schema box to specify the schema that you want your alias to belong to. The schema can be either an existing one or a new one.
  3. In the Alias name field, type the alias without its qualifier.
  4. Use the Object schema box to specify either the schema of the table or view, or the schema of another alias for the table or view. The table, view, or other alias can be one that exists or one that you plan to create. If you plan to create it, you can specify either an existing schema or a new one.
  5. In the Object name field, specify the object whose schema you specified in the Object schema box. If the object is a table or view, type its name without a qualifier. If the object is an alias, type this alias without a qualifier.
  6. Optional: In the Comment field, document the alias that you're creating.
  7. Click on Apply to create the alias. If you specified a new schema in the Alias schema field, and you have IMPLICIT_SCHEMA authority, this schema will be created also.
  8. Repeat steps 2 through 7 for each additional alias that you want to create.
  9. Click on Close to close the Create Alias window.


Related information