Modifies the properties, columns, or constraints for an existing stream.
In this Topic:
ALTER STREAM [ IF EXISTS ] <name> SET COMMENT = '<string_literal>' ALTER STREAM [ IF EXISTS ] <name> UNSET COMMENT
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.
Specifies the properties to set for the stream:
COMMENT = 'string'
Adds a comment or overwrites an existing comment for the stream.
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.
Add a comment for a stream:
ALTER STREAM mystream SET COMMENT = 'New comment for stream';