Neoview SQL Reference Manual (R2.4 SP2)

Examples of DROP TABLE............................................................................................................116
DROP TRIGGER Statement................................................................................................................117
Syntax Description of DROP TRIGGER........................................................................................117
Considerations for DROP TRIGGER.............................................................................................117
Example of DROP TRIGGER.........................................................................................................117
DROP VIEW Statement.......................................................................................................................118
Syntax Description of DROP VIEW...............................................................................................118
Considerations for DROP VIEW...................................................................................................118
Example of DROP VIEW...............................................................................................................118
EXECUTE Statement...........................................................................................................................119
Syntax Description of EXECUTE...................................................................................................119
Considerations for EXECUTE........................................................................................................120
Examples of EXECUTE..................................................................................................................120
EXPLAIN Statement............................................................................................................................122
Syntax Description of EXPLAIN...................................................................................................122
Considerations for EXPLAIN........................................................................................................123
GET SERVICE Statement....................................................................................................................133
Syntax Description of GET SERVICE............................................................................................133
Considerations for GET SERVICE.................................................................................................133
Examples of GET SERVICE...........................................................................................................133
GRANT Statement..............................................................................................................................135
Syntax Description of GRANT......................................................................................................135
Considerations for GRANT...........................................................................................................136
Examples of GRANT.....................................................................................................................136
GRANT EXECUTE Statement.............................................................................................................137
Syntax Description of GRANT EXECUTE.....................................................................................137
Considerations for GRANT EXECUTE.........................................................................................137
Examples of GRANT EXECUTE....................................................................................................138
GRANT SCHEMA Statement.............................................................................................................139
Syntax Description of GRANT SCHEMA.....................................................................................139
Considerations for GRANT SCHEMA..........................................................................................141
Examples of GRANT SCHEMA....................................................................................................142
INSERT Statement...............................................................................................................................143
Syntax Description of INSERT.......................................................................................................143
Considerations for INSERT...........................................................................................................144
Examples of INSERT......................................................................................................................145
LOCK TABLE Statement.....................................................................................................................148
Syntax Description of LOCK TABLE.............................................................................................148
Considerations for LOCK TABLE..................................................................................................148
Examples of LOCK TABLE............................................................................................................149
MERGE INTO Statement....................................................................................................................150
Syntax Description of MERGE INTO............................................................................................150
Considerations for MERGE INTO.................................................................................................150
Example of MERGE.......................................................................................................................152
PREPARE Statement...........................................................................................................................153
Syntax Description of PREPARE...................................................................................................153
Considerations for PREPARE........................................................................................................153
Examples of PREPARE..................................................................................................................153
REVOKE Statement.............................................................................................................................155
Syntax Description of REVOKE.....................................................................................................155
Considerations for REVOKE.........................................................................................................156
Examples of REVOKE....................................................................................................................156
REVOKE EXECUTE Statement...........................................................................................................157
Syntax Description of REVOKE EXECUTE...................................................................................157
Considerations for REVOKE EXECUTE........................................................................................158
6 Table of Contents