Neoview SQL Reference Manual (R2.4)

Considerations for DROP TRIGGER.............................................................................................115
Example of DROP TRIGGER.........................................................................................................115
DROP VIEW Statement.......................................................................................................................116
Syntax Description of DROP VIEW...............................................................................................116
Considerations for DROP VIEW...................................................................................................116
Example of DROP VIEW...............................................................................................................116
EXECUTE Statement...........................................................................................................................117
Syntax Description of EXECUTE...................................................................................................117
Considerations for EXECUTE........................................................................................................118
Examples of EXECUTE..................................................................................................................118
EXPLAIN Statement............................................................................................................................120
Syntax Description of EXPLAIN...................................................................................................120
Considerations for EXPLAIN........................................................................................................121
GET SERVICE Statement....................................................................................................................131
Syntax Description of GET SERVICE............................................................................................131
Considerations for GET SERVICE.................................................................................................131
Examples of GET SERVICE...........................................................................................................131
GRANT Statement..............................................................................................................................133
Syntax Description of GRANT......................................................................................................133
Considerations for GRANT...........................................................................................................134
Examples of GRANT.....................................................................................................................134
GRANT EXECUTE Statement.............................................................................................................135
Syntax Description of GRANT EXECUTE.....................................................................................135
Considerations for GRANT EXECUTE.........................................................................................135
Examples of GRANT EXECUTE....................................................................................................136
GRANT SCHEMA Statement.............................................................................................................137
Syntax Description of GRANT SCHEMA.....................................................................................137
Considerations for GRANT SCHEMA..........................................................................................139
Examples of GRANT SCHEMA....................................................................................................140
INSERT Statement...............................................................................................................................141
Syntax Description of INSERT.......................................................................................................141
Considerations for INSERT...........................................................................................................143
Examples of INSERT......................................................................................................................145
LOCK TABLE Statement.....................................................................................................................147
Syntax Description of LOCK TABLE.............................................................................................147
Considerations for LOCK TABLE..................................................................................................147
Examples of LOCK TABLE............................................................................................................148
MERGE INTO Statement....................................................................................................................149
Syntax Description of MERGE INTO............................................................................................149
Considerations for MERGE INTO.................................................................................................149
PREPARE Statement...........................................................................................................................152
Syntax Description of PREPARE...................................................................................................152
Considerations for PREPARE........................................................................................................152
Examples of PREPARE..................................................................................................................152
REVOKE Statement.............................................................................................................................154
Syntax Description of REVOKE.....................................................................................................154
Considerations for REVOKE.........................................................................................................155
Examples of REVOKE....................................................................................................................155
REVOKE EXECUTE Statement...........................................................................................................156
Syntax Description of REVOKE EXECUTE...................................................................................156
Considerations for REVOKE EXECUTE........................................................................................157
Examples of REVOKE EXECUTE..................................................................................................157
REVOKE SCHEMA Statement............................................................................................................158
Syntax Description of REVOKE SCHEMA....................................................................................158
Considerations for REVOKE SCHEMA........................................................................................160
6 Table of Contents