Online Documentation for SQL Manager for DB2

Schema Objects

A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user. Each user can own a single schema. Schema objects can be created and manipulated with SQL and include the following types of objects:

• Tables
• Views
• Procedures
• Aliases
• Functions
• Materialized Query Tables
• Nicknames
• Sequences
• User-Defined (Structured) Types
• User-Defined Types
• Packages
• Triggers
• Indices
• SQL Variables
• Global Temporary Tables
• Modules

Use the DB Explorer tree to navigate within the existing schemas and their objects.