Creating an alias

Authorities and privileges

To create an alias:

1. Open the Create Alias window:
   1. Right-click on the Aliases folder in the object tree.
   2. Select Create from the pop-up menu.
2. In the Alias owner field, specify the user ID for the owner of the alias.

   Tip: To display a list of existing objects, click on the  (Browse) button next to the field. Select an existing object from the list.

3. In the Alias name field, type a name for the alias that you are creating. This name cannot identify an existing table, view, alias, or synonym on the current server.
4. In the Object location field, specify the location of the object for which you are creating an alias.
   • If you leave this field blank, the alias for an object at the current server, is created with a two-part name. For example, the alias, myalias, which is owned by the user ID, userid, and is for an object on the current server is named: userid.myalias.
   • If you specify the name of another server, then the alias is created with a three-part name. For example, the alias, myalias, which is owned by the user ID, userid, and is for an object on the server, DB2XYZ123 is named: DB2XYZ123.userid.myalias.
5. In the Object owner field, type the owner of the object for which you are creating an alias.
6. In the Object name field, type the name of the object for which you are creating an alias.

   Important: If you are defining an alias for an object on a different server, then existence of this object is not verified when the alias is created. If this object does not exist, statements that include this alias will not run properly.

7. Optional: In the Comment field, type a description of the alias. You can type up to 254 characters.
8. Click OK to commit your change.

• Altering an alias