Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
More options
HP.com home
 ALLBASE/SQL Reference Manual: HP 9000 Computer Systems > Chapter 1 Introduction

ALLBASE/SQL Objects
» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

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



Using Queries
  		 


ALLBASE/SQL Users  
Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© Hewlett-Packard Development Company, L.P.