Aliases Wizard (DB2 LUW)
Go Up to IBM DB2 for Linux, Unix, and Windows Object Wizards
An alias offers you security and convenience so that you can refer to an object without revealing who owns it or what database it belongs to. You can create aliases for tables, views, and even other aliases. The Alias Wizard lets you create an alias without knowing the underlying commands. As you complete the Alias Wizard process, a CREATE ALIAS statement is generated based on the information that you supply.
To create a new alias using a wizard:
- Open a creation wizard for an alias. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details see Aliases (DB2 LUW) - Properties.
- Comment panel - for details, see Adding a Comment to an Object.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Aliases (DB2 LUW) - Properties
When creating or editing an alias, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Schema |
Select the schema that is to own the alias. |
Name |
Provide a name for the alias |
Target Owner |
Select the owner of the object to which you are creating an alias. |
Target Type |
Select the type of object to which you want to create an alias. |
Target Name |
Select the specific object to which you are creating an alias. |
For context information on the wizard and editor that include this tab/panel, see Aliases Wizard (DB2 LUW) and Aliases Editor (IBM DB2 LUW).