HPlogo ALLBASE/SQL Reference Manual: HP 9000 Computer Systems > Chapter 1 Introduction

ALLBASE/SQL Objects

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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

Feedback to webmaster