Type schema

Use this box to specify the schema of the distinct type that you're creating. 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. The schema can be an existing one or, if you have IMPLICIT_SCHEMA authority, it can be a new one. This name:

  • Can contain up 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 ]