HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems

Chapter 5 Database Creation and Security

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Once the DBEnvironment is configured and storage is allocated, you can begin creating the tables, views, indexes, and other objects that comprise databases. The examples in this chapter show the statements for creating specific tables, views, and authorities within the sample DBEnvironment PartsDBE. A complete set of statements for creating all the tables, views, and authorities in PartsDBE is found in the "Sample DBEnvironment" appendix of the ALLBASE/SQL Reference Manual.

Tasks presented in this chapter are:

  • Creating tables

  • Creating views

  • Creating hash structures

  • Creating indexes

  • Creating procedures and rules

  • Creating the database security scheme

  • Creating a database schema

  • Loading tables

Feedback to webmaster