Table Of Contents

6.3. Drop table

6.3.1. Synopsis

DROP TABLE

{ <entries> | <find_expression> } [, ... ]

find_expression ::=
  FIND ( { <tag_expression> | NOT <tag_expression> } [ AND ... ] )

tag_expression ::=
  TAG = 'tag_name'

6.3.2. Description

DROP TABLE will drop one or more existing table from your QuasarDB cluster. The statement is executed immediately and does not require confirmation, so use with caution. The statement is transactional.

6.3.3. Parameters

entries
The name of the entries that will be dropped.
find_expression
When your tables are tagged, you can use inline key/value lookups to perform your query over multiple tables. To match all tables that have the tag “stocks”, you can use FIND(tag='stocks' AND type=ts).

6.3.4. Examples

Drop a table:

DROP TABLE example

Drop all table tagged with ‘nyse’:

DROP TABLE FIND(tag='nyse')
arrow_backPrevious
6.2. Delete from
Next arrow_forward
6.4. Alter table