Removes a stream from the current/specified schema.
- See also:
CREATE STREAM , ALTER STREAM , SHOW STREAMS , DESCRIBE STREAM
DROP STREAM [ IF EXISTS ] <name>
Specifies the identifier for the stream to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive (e.g.
If the stream identifier is not fully-qualified (in the form of
schema_name.stream_name), the command looks for the stream in the current schema for the session.
Drop a stream:
SHOW STREAMS LIKE 't2%'; DROP STREAM t2; SHOW STREAMS LIKE 't2%';
Drop the stream again, but don’t raise an error if the stream does not exist:
DROP STREAM IF EXISTS t2;