Neoview SQL Reference Manual (R2.3)

Considerations for CREATE TRIGGER...........................................................................................83
Authorization and Availability Requirements...........................................................................83
Trigger Types..............................................................................................................................83
Restrictions on Triggers..............................................................................................................85
Recompilation and Triggers.......................................................................................................85
Triggers and Primary Keys........................................................................................................85
Examples of CREATE TRIGGER.....................................................................................................86
Before and After Triggers...........................................................................................................86
CREATE VIEW Statement.....................................................................................................................88
Syntax Description of CREATE VIEW.............................................................................................88
Considerations for CREATE VIEW.................................................................................................89
Reserved View Names...............................................................................................................89
Effect of Adding a Column on View Definitions.......................................................................89
Authorization and Availability Requirements...........................................................................89
Updatable and Non-Updatable Views.......................................................................................89
Examples of CREATE VIEW............................................................................................................90
DELETE Statement................................................................................................................................91
Syntax Description of DELETE........................................................................................................91
Considerations for DELETE............................................................................................................93
Authorization Requirements......................................................................................................93
Transaction Initiation and Termination......................................................................................93
Isolation Levels of Transactions and Access Options of Statements..........................................93
Long Running Delete ................................................................................................................93
SET ON ROLLBACK Considerations........................................................................................94
SET ON ROLLBACK Restrictions..............................................................................................94
Examples of DELETE.......................................................................................................................94
DROP INDEX Statement.......................................................................................................................95
Syntax Description of DROP INDEX..............................................................................................95
Considerations for DROP INDEX...................................................................................................95
Authorization and Availability Requirements...........................................................................95
Indexes That Support Constraints.............................................................................................95
Example of DROP INDEX...............................................................................................................95
DROP MATERIALIZED VIEW Statement............................................................................................96
Syntax Description of DROP MATERIALIZED VIEW....................................................................96
Example of DROP MATERIALIZED VIEW....................................................................................96
DROP MVGROUP Statement...............................................................................................................97
Considerations for DROP MVGROUP............................................................................................97
Authorization and Availability Requirements...........................................................................97
Example of DROP MVGROUP........................................................................................................97
DROP SCHEMA Statement..................................................................................................................98
Syntax Description of DROP SCHEMA..........................................................................................98
Considerations for DROP SCHEMA...............................................................................................98
Authorization and Availability Requirements...........................................................................98
Transaction Limits on DROP SCHEMA.....................................................................................98
Example of DROP SCHEMA...........................................................................................................98
DROP SYNONYM Statement...............................................................................................................99
Syntax Description of DROP SYNONYM ......................................................................................99
Considerations.................................................................................................................................99
Example of DROP SYNONYM........................................................................................................99
DROP TABLE Statement.....................................................................................................................100
Syntax Description of DROP TABLE.............................................................................................100
Considerations for DROP TABLE..................................................................................................100
Authorization and Availability Requirements.........................................................................100
Example of DROP TABLE.............................................................................................................100
DROP TRIGGER Statement................................................................................................................101
6 Table of Contents