Categories:

Table, View, & Sequence DDL

ALTER STREAM

Modifies the properties, columns, or constraints for an existing stream.

See also:

CREATE STREAM , DROP STREAM , SHOW STREAMS

In this Topic:

Syntax

ALTER STREAM [ IF EXISTS ] <name> SET COMMENT = '<string_literal>'

ALTER STREAM [ IF EXISTS ] <name> UNSET COMMENT

Parameters

name

Identifier for the stream to alter. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

SET ...

Specifies the properties to set for the stream:

COMMENT = 'string'

Adds a comment or overwrites an existing comment for the stream.

UNSET ...

Specifies the properties to unset for the stream, which resets them to the defaults.

Currently, the only property you can unset is COMMENT, which removes the comment, if one exists, for the stream.

Examples

Add a comment for a stream:

ALTER STREAM mystream SET COMMENT = 'New comment for stream';