Neoview SQL Reference Manual (R2.3)

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 44)
Adds or removes member materialized views from a
materialized view group (MVGROUP).
“ALTER MVGROUP Statement” (page 45)
Changes synonyms or aliases for tables.“ALTER SYNONYM Statement” (page 46)
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 51)
Changes table.“ALTER TABLE Statement” (page 47)
Alters trigger status.“ALTER TRIGGER Statement” (page 50)
Creates an index on a table.“CREATE INDEX Statement” (page 58)
Creates a materialized view.“CREATE MATERIALIZED VIEW Statement” (page 60)
Creates a logical collection of materialized views.“CREATE MVGROUP Statement” (page 66)
Creates a schema.“CREATE SCHEMA Statement” (page 67)
Creates synonym or alias for tables.“CREATE SYNONYM Statement” (page 68)
Creates a table.“CREATE TABLE Statement” (page 69)
Creates a trigger.“CREATE TRIGGER Statement” (page 82)
Creates a view.“CREATE VIEW Statement” (page 88)
Drops an index.“DROP INDEX Statement” (page 95)
Drops a materialized view.“DROP MATERIALIZED VIEW Statement” (page 96)
Drops a materialized group.“DROP MVGROUP Statement” (page 97)
Drops a schema.“DROP SCHEMA Statement” (page 98)
Drops a synonym.“DROP SYNONYM Statement” (page 99)
Drops a table.“DROP TABLE Statement” (page 100)
Drops a trigger.“DROP TRIGGER Statement” (page 101)
Categories 41