Neoview Database Administrator's Guide (R2.4)

5 Managing Database Objects

This chapter describes how to manage your database using the DB Admin tool.

The Neoview platform also supports a client-based utility, Neoview Command Interface, which

enables you to enter SQL statements interactively or from script files in its command-line interface.

You can also pass an SQL statement to NCI from a Perl or Python command line or from a Perl

or Python program. For more information, see the Neoview Command Interface (NCI) Guide.

To perform maintenance tasks such as scheduling update statistics or defragment operations,

see “Schedule Maintain Wizard” (page 87).

For SQL syntax, see the HP Neoview SQL Reference Manual. For descriptions of creating and

managing stored procedures in Java (SPJs), see the Neoview Guide to Stored Procedures in Java.

This chapter describes:

• “Schemas” (page 38)

— “Displaying Schemas and Their Objects” (page 38)

— “Creating Schemas” (page 42)

— “Granting and Revoking Access (Privileges) to a Schema” (page 43)

— “Displaying Schema DDL Information” (page 43)

— “Dropping (Deleting) Schemas” (page 44)

• “Tables” (page 44)

— “Creating Tables ” (page 45)

— “Creating Tables From Existing Tables” (page 49)

— “Creating Tables Using the Create Table Tool” (page 50)

— “Granting and Revoking Access (Privileges) to a Table” (page 52)

— “Displaying Tables and Their Properties” (page 53)

— “Displaying Table DDL Information” (page 56)

— “Adding Columns to a Table” (page 57)

— “Changing Table Attributes” (page 58)

— “Changing Table Columns” (page 59)

— “Renaming Tables” (page 59)

— “Enabling or Disabling Reorganize and Update Statistics on Tables” (page 60)

— “Dropping (Deleting) Tables” (page 60)

• “Triggers” (page 65)

— “Creating Triggers on Tables” (page 65)

— “Displaying Triggers and Their Properties” (page 68)

— “Enabling or Disabling Triggers on Tables” (page 69)

• “Indexes” (page 61)

— “Creating Indexes” (page 61)

— “Displaying Indexes and Their Properties” (page 64)

— “Dropping (Deleting) Indexes” (page 64)

• “Views” (page 69)

— “Creating Views” (page 69)

— “Displaying Views and Their Properties” (page 70)

— “Renaming Views” (page 71)

— “Dropping (Deleting) Views” (page 72)

• “Materialized Views” (page 72)

• “Creating Materialized Views” (page 72)