Neoview Database Administrator's Guide (R2.5)

For SQL syntax, see the Neoview SQL Reference Manual. For descriptions of creating and managing
stored procedures in Java (SPJs), see the Neoview Guide to Stored Procedures in Java.
Table 3-1 Managing Database Objects
Use this tool...To Perform This Action...Database Object
NCICreatingSchemas
NCIGranting/Revoking Privileges to/from
HPDMDisplaying attribute, SQL space, and DDL
information
NCIDropping (deleting)
NCICreating or Creating from an existing tableTables
HPDMDisplaying attribute, SQL space, and DDL
information
NCICreating using DDL
NCIGranting/Revoking Privileges to/from
NCIAdding or changing columns
NCIChanging attributes
NCIRenaming
See Chapter 5 (page 25)Reorganizing and Update Statistics
NCIDropping (deleting)
NCI
HPDM
Creating, enabling and disabling
Displaying attribute, SQL space, and DDL
information
Triggers
NCI
HPDM
Creating and dropping (deleting)
Display attribute, SQL space, and DDL
information
Indexes
NCI
HPDM
Creating, renaming, or dropping
Displaying attribute, SQL space, and DDL
information
Views
NCI
HPDM
Creating, changing, or dropping
Displaying attribute, SQL space, and DDL
information
Materialized Views
NCI
HPDM
Creating, changing, or dropping
Displaying attribute, SQL space, and DDL
information
Materialized View
groups
NCI
HPDM
Creating, changing, or dropping
Displaying attribute, SQL space, and DDL
information
Synonyms
20 Guidelines for Database Administrators