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 Database Administration Guide: HP 9000 Computer Systems

Chapter 5 Database Creation and Security
» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

Table of Contents

Creating Tables
Table Type
Owner and Table Name
Column Definition
Constraint Definitions
DBEFileSet Name
Examining Table Attributes
Defining Partitions and Tables
Creating Views
Creating Hash Structures
Creating Indexes
Creating Procedures and Rules
Creating a Procedure
Creating a Rule
Creating the Database Security Scheme
Controlling Table Access with Authorities
Controlling Table Access with Views
Using the GRANT OPTION Clause
Creating a Database Schema
Loading Tables
Loading from an External File
Loading from an Internal File
Loading Tables with Constraints on Them
Loading Tables with Rules Built on Them
Using Command Files for Loading

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



Managing DBEnvironment Sessions
  		 


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