HP 3000 Manuals

ALLBASE/SQL Reference Manual

ALLBASE/SQL Objects 

The following structures play a significant role in the use of an
ALLBASE/SQL database and are known as database objects:

   *   Tables
   *   Views
   *   Columns (in tables and views)
   *   Authorization groups
   *   Indexes (on tables)
   *   Hash structures (for tables)
   *   Constraints
   *   Rules (on tables)
   *   Procedures
   *   DBEFiles
   *   DBEFileSets
   *   TempSpaces
   *   Modules

Many of the SQL statements let you create and then create and manipulate
objects as described below:

   *   Data in tables and views
   *   Columns within tables and views
   *   Grant authorities to authorization groups
   *   Indexes for specific tables
   *   Hash structures for specific tables
   *   Constraints on specific tables, views, or columns
   *   Rules on specific tables
   *   Procedures containing SQL and control flow statements
   *   DBEFiles and associate them with DBEFileSets
   *   TempSpaces that are used for sorting
   *   Modules when you preprocess an application program containing SQL
       statements

MPE/iX 5.5 Documentation