ALLBASE/SQL Reference Manual (36216-90216)

50 Chapter1
Introduction
ALLBASE/SQL Objects
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