DROP RELATION

Synopsis

DROP RELATION relation_name;

Description

Drops an existing Relation. It can only be executed by the Relation owner. A Relation cannot be dropped if there exists any queries that depend on that Relation. Note that deleting the Relation does not delete the Relation's underlying Topic.

DROP RELATION cannot be undone. Use it with care!

A Relation cannot be dropped if there exist any references to that Relation

Arguments

relation_name

The name of the Relation to drop. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

Example

Drop a Relation using default Database and Schema

The following shows how to drop the Relation named pageviews:

demodb.public/demostore# LIST RELATIONS;
    Name    |  Type  |  Owner   |      Created at      |      Updated at
------------+--------+----------+----------------------+-----------------------
  pageviews | Stream | sysadmin | 2023-02-06T16:14:22Z | 2023-02-06T16:14:22Z

demodb.public/demostore# DROP RELATION pageviews;
demodb.public/demostore# LIST RELATIONS;
  Name | Type | Owner | Created at | Updated at
-------+------+-------+------------+-------------

Drop a Relation using fully qualified name

The following shows how to drop the Relation named PageViews in the Database OtherDB and Schema S1:

demodb.public/demostore# LIST RELATIONS IN SCHEMA "OtherDB"."S1";
    Name    |  Type  |  Owner   |      Created at      |      Updated at
------------+--------+----------+----------------------+-----------------------
  PageViews | Stream | sysadmin | 2023-02-06T16:14:22Z | 2023-02-06T16:14:22Z

demodb.public/demostore# DROP RELATION "OtherDB"."S1"."PageViews";
demodb.public/demostore# LIST RELATIONS IN SCHEMA "OtherDB"."S1";
  Name | Type | Owner | Created at | Updated at
-------+------+-------+------------+-------------