Neoview SQL Reference Manual (R2.2)

DROP MVGROUP Statement
• “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 254).
DROP MVGROUP mv-group-name
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.
Example of DROP MVGROUP
• This example drops a materialized view group:
DROP MVGROUP pgroup
DROP MVGROUP Statement 95