Neoview SQL Reference Manual (R2.4)

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 the command-line
interface, Neoview Command Interface (NCI). For information on Neoview Command Interface,
see the Neoview Command Interface (NCI) 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”
• “Trigger 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 42)
Adds or removes member materialized views from a
materialized view group (MVGROUP).
“ALTER MVGROUP Statement” (page 43)
Changes synonyms or aliases for tables.“ALTER SYNONYM Statement” (page 44)
Changes table.“ALTER TABLE Statement” (page 45)
Alters trigger status.“ALTER TRIGGER Statement” (page 52)
Adds a constraint or column to a table or view, drops
existing constraints, or changes file attributes of a table or
view.
“ALTER VIEW Statement” (page 53)
Creates an index on a table.“CREATE INDEX Statement” (page 59)
Creates a materialized view.“CREATE MATERIALIZED VIEW Statement” (page 61)
Creates a logical collection of materialized views.“CREATE MVGROUP Statement” (page 67)
Creates a schema.“CREATE SCHEMA Statement” (page 68)
Creates synonym or alias for tables.“CREATE SYNONYM Statement” (page 69)
Creates a table.“CREATE TABLE Statement” (page 70)
Creates a trigger.“CREATE TRIGGER Statement” (page 93)
Creates a view.“CREATE VIEW Statement” (page 99)
Drops an index.“DROP INDEX Statement” (page 109)
Drops a materialized view.“DROP MATERIALIZED VIEW Statement” (page 110)
Drops a materialized group.“DROP MVGROUP Statement” (page 111)
Drops a schema.“DROP SCHEMA Statement” (page 112)
Drops a synonym.“DROP SYNONYM Statement” (page 113)
Drops a table.“DROP TABLE Statement” (page 114)
Drops a trigger.“DROP TRIGGER Statement” (page 115)
Categories 39