Neoview Database Administrator's Guide (R2.3)

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 85).

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 36)

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

— “Creating Schemas” (page 40)

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

— “Displaying Schema DDL Information” (page 41)

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

• “Tables” (page 42)

— “Creating Tables ” (page 43)

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

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

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

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

— “Displaying Table DDL Information” (page 54)

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

— “Changing Table Attributes” (page 56)

— “Renaming Tables” (page 57)

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

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

• “Triggers” (page 63)

— “Creating Triggers on Tables” (page 63)

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

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

• “Indexes” (page 58)

— “Creating Indexes” (page 58)

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

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

• “Views” (page 67)

— “Creating Views” (page 67)

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

— “Renaming Views” (page 69)

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

• “Materialized Views” (page 70)

• “Creating Materialized Views” (page 70)

• “Displaying Materialized Views and Their Properties” (page 75)