Object schema

Use this box to specify the schema of the table or view that you're creating an alias for, or the schema of another alias for this 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.

The initial value in this box is the user ID under which you connected to the database. To specify a schema with a name that's different than this ID, use one of these methods:

• Click on the down arrow to display a list of existing schemas and select one.

• Type the name of the schema that you want. If you want a new schema, its name:

  • Can contain from 1 to 8 characters

  • Cannot be one of the following reserved schema names:

    • SYSCAT

    • SYSFUN

    • SYSIBM

    • SYSSTAT

  • Can be an ordinary or delimited identifier

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]