Neoview Database Administrator's Guide (R2.2)

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, HP Neoview Script, 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 Script from a Perl or Python command line or from a Perl or

Python program. For more information, see the HP Neoview Script Guide.

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

see “Schedule Maintain Wizard” (page 77).

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

— “Displaying Schema DDL Information” (page 39)

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

• “Tables” (page 40)

— “Creating Tables ” (page 40)

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

— “Using the Create Table Tool to Import DDL From a File” (page 45)

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

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

— “Displaying Table DDL Information” (page 51)

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

— “Changing Table Attributes” (page 52)

— “Renaming Tables” (page 52)

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

— “Creating Triggers on Tables” (page 53)

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

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

• “Indexes” (page 57)

— “Creating Indexes” (page 57)

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

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

• “Views” (page 60)

— “Creating Views” (page 60)

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

— “Renaming Views” (page 62)

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

• “Materialized Views” (page 63)

• “Creating Materialized Views” (page 63)

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

• “Changing Materialized Views” (page 68)

• “Dropping (Deleting) Materialized Views” (page 69)