Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 | 

Dropping Tables

Description

You can drop an existing table by the DROP statement. Multiple tables can be dropped by a single DROP statement. All instances of table are also dropped.

Syntax

DROP [ table_type ] table_spec [ { ,table_spec }_ ] [ ; ]

table_type:
[TABLE | CLASS]
[VIEW | VCLASS]

table_spec:
single_table_spec
( single_table_spec [ { , single_class_spec }_ ] )

single_table_spec:
[ ONLY ] table_name
ALL table_name [ ( EXCEPT table_spec ) ]

  • table_type : Specifies the type of the table (normal or virtual) to be dropped.
  • table_name : Specifies the name of the table to be dropped.
Example

The following is an example of dropping the history table.

DROP TABLE history ;