- Categories:
ALTER STREAM¶
Modifies the properties, columns, or constraints for an existing stream.
- See also:
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.