Viewing DB2 Object Data in the Investigator › View Catalog Objects › Schemas

Schemas

When tables, views, indexes, and aliases are created, they are given a qualified name. When the qualified name is a two-part name, the first part (an authorization ID) is a qualifier that distinguishes the object from other objects that have the same name. The second part is the name of the object. To be consistent with the ANSI/ISO SQL92 standard, the concept of qualified names is extended to refer to the qualifier as a schema name. The qualifier of user‑defined distinct types (user-defined functions and triggers, and stored procedures), is a schema name.

All objects that are qualified by the same schema name can be thought of as a group of related objects. A schema name has a maximum length of 8 bytes.

You can use the Investigator to perform the following tasks:

• List cross-reference information for all schemas defined in the DB2 system.
• View the number of routines, distinct types, and triggers for a specific schema.
• View distinct type information such as the owner, source, schema, metatype. length, scale, and so on.
• View routine information such as the name, creator, owner, type, source, number of parameters, language, and so on.
• View trigger information such as the name, owner, time, event, granularity, and so on.
• View user authorization information such as grantee, grantor, authority level, and so on.