Neoview SQL Reference Manual (R2.5)

2 SQL Statements
This section describes the syntax and semantics of Neoview SQL statements.
The Neoview SQL statements and utilities are entered interactively or from script files using one
of these client-based utilities:
• The Neoview Command Interface (NCI). For information about NCI, see the Neoview
Command Interface (NCI) Guide.
• The HP Database Manager. For information about HPDM, see the HP Database Manager
(HPDM) User Guide.
Categories
The statements are categorized according to their functionality:
• “Data Definition Language (DDL) Statements”
• “Data Manipulation Language (DML) Statements”
• “Transaction Control Statements”
• “Resource Control and Optimization Statements”
• “Control Statements”
• “Object Naming Statements”
• “Stored Procedure Statements”
Data Definition Language (DDL) Statements
Use these DDL statements to define, delete, or modify the definition of a Neoview SQL schema,
or object, or the authorization to use an object.
Changes materialized views.“ALTER MATERIALIZED VIEW Statement” (page 40)
Adds or removes member materialized views from a
materialized view group (MVGROUP).
“ALTER MVGROUP Statement” (page 42)
Changes synonyms or aliases for tables.“ALTER SYNONYM Statement” (page 43)
Changes table.“ALTER TABLE Statement” (page 44)
Alters trigger status.“ALTER TRIGGER Statement” (page 53)
Renames an object within the same schema.“ALTER VIEW Statement” (page 54)
Creates an index on a table.“CREATE INDEX Statement” (page 60)
Creates a materialized view.“CREATE MATERIALIZED VIEW Statement” (page 63)
Creates a logical collection of materialized views.“CREATE MVGROUP Statement” (page 69)
Creates a schema.“CREATE SCHEMA Statement” (page 70)
Creates synonym or alias for tables.“CREATE SYNONYM Statement” (page 71)
Creates a table.“CREATE TABLE Statement” (page 72)
Creates a trigger.“CREATE TRIGGER Statement” (page 96)
Creates a view.“CREATE VIEW Statement” (page 102)
Drops an index.“DROP INDEX Statement” (page 113)
Drops a materialized view.“DROP MATERIALIZED VIEW Statement” (page 114)
Drops a materialized group.“DROP MVGROUP Statement” (page 115)
Drops a schema.“DROP SCHEMA Statement” (page 116)
Drops a synonym.“DROP SYNONYM Statement” (page 117)
Drops a table.“DROP TABLE Statement” (page 118)
Categories 37