Dropping Virtual Tables

Description

You can drop a virtual table by using the DROP statement. The way to drop a virtual table is the same as to drop a regular table.

Syntax

DROP [ VIEW | VCLASS ] view_spec [ { ,class_spec }... ] [ ; ]

view_spec :
single_view_spec
( single_view_spec [ { , single_view_spec }... ] )

single_view_spec :
[ ONLY ] view_name
ALL view_name [ ( EXCEPT view_spec ) ]

• view_name : Specifies the name of the virtual table to be dropped.

Example

The following is an example of dropping the virtual table 'swimming.'

DROP VIEW swimming;