Neoview SQL Reference Manual (R2.4 SP2)

DROP MVGROUP Statement
• “Syntax Description of DROP MVGROUP” (page 113)
• “Considerations for DROP MVGROUP”
• “Example of DROP MVGROUP”
The DROP MVGROUP statement allows you to drop materialized view groups.
For information on MVGROUPS, see “MVGROUPs ” (page 269).
DROP MVGROUP mv-group-name
Syntax Description of DROP MVGROUP
mv-group-name
specifies the materialized view group name to drop.
Considerations for DROP MVGROUP
• Dropping an MVGROUP does not affect the MVs that were part of the group.
• You do not need to cleanup the contents of the group prior to dropping the MVGROUP.
Authorization and Availability Requirements
To drop an mvgroup, you must be the owner of the mvgroup or the owner of the schema.
Example of DROP MVGROUP
• This example drops a materialized view group:
DROP MVGROUP pgroup
DROP MVGROUP Statement 113