Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 | 

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;