DROP STREAM

Syntax

DROP STREAM stream_name;

Description

Drops an existing relation. Only the stream owner can execute this command.

Notes

• You cannot drop a stream if there exist any references to that stream or queries that depend on that stream.

• Deleting the stream does not delete the stream's underlying entity.

Important DROP STREAM cannot be undone. Use it with care!

Arguments

stream_name

The name of the stream to drop. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.

Example

Drop a stream using default database and schema

The following shows how to drop the stream named pageviews:

demodb.public/demostore# LIST STREAMS;
 Name        |  Type  |  Owner   |  State  |      Created at      |      Updated at       
-------------+--------+----------+---------+----------------------+-----------------------
  pageviews  | Stream | sysadmin | Created | 2024-06-06T22:57:54Z | 2024-06-06T22:57:56Z  
    
demodb.public/demostore# DROP STREAM pageviews;
demodb.public/demostore# LIST STREAMS;
  Name        |  Type  |  Owner   |  State  |      Created at      |      Updated at       
--------------+--------+----------+---------+----------------------+-----------------------

Drop a stream using a fully-qualified name

The following shows how to drop the stream named pageviews in the database otherdb and schema s1:

demodb.public/demostore# LIST STREAMS IN SCHEMA otherdb.s1;

     Name    |  Type  |  Owner   |  State  |      Created at      |      Updated at       
-------------+--------+----------+---------+----------------------+-----------------------
  pageviews  | Stream | sysadmin | Created | 2024-06-06T22:57:54Z | 2024-06-06T22:57:56Z  

demodb.public/demostore# DROP STREAM otherdb.s1.pageviews;
demodb.public/demostore# LIST STREAMS IN SCHEMA otherdb.s1;
  Name | Type | Owner | Created at | Updated at
-------+------+-------+------------+-------------