Neoview SQL Reference Manual (R2.4 SP2)

ALTER MATERIALIZED VIEW Statement..........................................................................................40
Syntax Description of ALTER MATERIALIZED VIEW..................................................................40
Considerations for ALTER MATERIALIZED VIEW.......................................................................40
Example of ALTER MATERIALIZED VIEW...................................................................................41
ALTER MVGROUP Statement..............................................................................................................42
Syntax Description of ALTER MVGROUP.....................................................................................42
Considerations for ALTER MVGROUP..........................................................................................42
Examples of ALTER MVGROUP.....................................................................................................42
ALTER SYNONYM Statement..............................................................................................................43
Syntax Description of ALTER SYNONYM......................................................................................43
Considerations for ALTER SYNONYM..........................................................................................43
Example of ALTER SYNONYM......................................................................................................43
ALTER TABLE Statement.....................................................................................................................44
Syntax Description of ALTER TABLE.............................................................................................45
Considerations for ALTER TABLE..................................................................................................48
Recalibrating an IDENTITY Column..............................................................................................49
Example of ALTER TABLE ALTER COLUMN...............................................................................51
Example of ALTER TABLE..............................................................................................................52
ALTER TRIGGER Statement.................................................................................................................53
Syntax Description of ALTER TRIGGER.........................................................................................53
Considerations for ALTER TRIGGER.............................................................................................53
Examples of ALTER TRIGGER........................................................................................................53
ALTER VIEW Statement.......................................................................................................................54
Syntax Description of ALTER VIEW...............................................................................................54
Considerations for ALTER VIEW....................................................................................................54
Example of ALTER VIEW................................................................................................................54
BEGIN WORK Statement.....................................................................................................................55
Considerations for BEGIN WORK..................................................................................................55
Example of BEGIN WORK..............................................................................................................55
CALL Statement....................................................................................................................................56
Syntax Description of CALL............................................................................................................56
Considerations for CALL................................................................................................................56
Examples of CALL...........................................................................................................................57
COMMIT WORK Statement.................................................................................................................59
Considerations for COMMIT WORK..............................................................................................59
Example of COMMIT WORK..........................................................................................................59
CREATE INDEX Statement...................................................................................................................60
Syntax Description of CREATE INDEX..........................................................................................60
Considerations for CREATE INDEX...............................................................................................61
Example of CREATE INDEX...........................................................................................................62
CREATE MATERIALIZED VIEW Statement........................................................................................63
Syntax Description of CREATE MATERIALIZED VIEW................................................................63
Considerations for CREATE MATERIALIZED VIEW....................................................................65
Examples of CREATE MATERIALIZED VIEW...............................................................................67
CREATE MVGROUP Statement...........................................................................................................69
Considerations for MVGROUP.......................................................................................................69
Example of CREATE MVGROUP....................................................................................................69
CREATE SCHEMA Statement..............................................................................................................70
Syntax Description of CREATE SCHEMA......................................................................................70
Considerations for CREATE SCHEMA...........................................................................................70
Example of CREATE SCHEMA.......................................................................................................70
CREATE SYNONYM Statement...........................................................................................................71
Syntax Description of CREATE SYNONYM ..................................................................................71
Considerations for CREATE SYNONYM........................................................................................71
Example of CREATE SYNONYM....................................................................................................71
4 Table of Contents