Drops an existing . 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.
ImportantDROP 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
-------+------+-------+------------+-------------