Neoview SQL Reference Manual (R2.4)

Trigger Statements...........................................................................................................................41
Stored Procedure Statements...........................................................................................................41
ALTER MATERIALIZED VIEW Statement..........................................................................................42
Syntax Description of ALTER MATERIALIZED VIEW..................................................................42
Considerations for ALTER MATERIALIZED VIEW.......................................................................42
ALTER MVGROUP Statement..............................................................................................................43
Syntax Description of ALTER MVGROUP.....................................................................................43
Considerations for ALTER MVGROUP..........................................................................................43
Example of ALTER MVGROUP......................................................................................................43
ALTER SYNONYM Statement..............................................................................................................44
Syntax Description of ALTER SYNONYM......................................................................................44
Considerations for ALTER SYNONYM..........................................................................................44
Example of ALTER SYNONYM......................................................................................................44
ALTER TABLE Statement.....................................................................................................................45
Syntax Description of ALTER TABLE.............................................................................................47
Considerations for ALTER TABLE..................................................................................................49
Example of ALTER TABLE..............................................................................................................50
Example of ALTER TABLE ALTER COLUMN...............................................................................50
ALTER TRIGGER Statement.................................................................................................................52
Syntax Description of ALTER TRIGGER.........................................................................................52
Considerations for ALTER TRIGGER.............................................................................................52
ALTER VIEW Statement.......................................................................................................................53
Syntax Description of ALTER VIEW...............................................................................................53
Considerations for ALTER VIEW....................................................................................................53
Example of ALTER VIEW................................................................................................................53
BEGIN WORK Statement.....................................................................................................................54
Syntax Description of BEGIN WORK.............................................................................................54
Examples of BEGIN WORK............................................................................................................54
CALL Statement....................................................................................................................................55
Syntax Description of CALL............................................................................................................55
Considerations for CALL................................................................................................................55
Examples of CALL...........................................................................................................................56
COMMIT WORK Statement.................................................................................................................58
Considerations for COMMIT WORK..............................................................................................58
Example of COMMIT WORK..........................................................................................................58
CREATE INDEX Statement...................................................................................................................59
Syntax Description of CREATE INDEX..........................................................................................59
Considerations for CREATE INDEX...............................................................................................60
Example of CREATE INDEX...........................................................................................................60
CREATE MATERIALIZED VIEW Statement........................................................................................61
Syntax Description of CREATE MATERIALIZED VIEW................................................................62
Considerations for CREATE MATERIALIZED VIEW....................................................................63
Examples of CREATE MATERIALIZED VIEW...............................................................................66
CREATE MVGROUP Statement...........................................................................................................67
Authorization and Availability Requirements................................................................................67
Example of CREATE MVGROUP....................................................................................................67
CREATE SCHEMA Statement..............................................................................................................68
Syntax Description of CREATE SCHEMA......................................................................................68
Considerations for CREATE SCHEMA...........................................................................................68
Example of CREATE SCHEMA.......................................................................................................68
CREATE SYNONYM Statement...........................................................................................................69
Syntax Description of CREATE SYNONYM ..................................................................................69
Considerations for CREATE SYNONYM........................................................................................69
Example of CREATE SYNONYM....................................................................................................69
CREATE TABLE Statement...................................................................................................................70
4 Table of Contents