ALTER STREAM
Name
ALTER STREAM
-- associate or disaaociate wrappers and streams
Synopsis
ALTER STREAM stream
ADD WRAPPER wrapper
[with bindings (stream_column,[...])]
ALTER STREAM stream
DROP WRAPPER wrapper
Inputs
- stream
The name (possibly schema-qualified) of an existing stream to
alter.
- wrapper
The name of the wrapper that is to be associated with or disassociated from the stream
- stream_column
Values for the columns in this list must be provided to the wrapper as inputs and are used by the wrapper to produce output tuples. As a consequence, queries using streams with binding columns must make sure that the query executor can obtain values for these columns during query processing.
Outputs
- ALTER STREAM
Message returned from column or table renaming.
- ERROR
Message returned if table or column is not available.
Description
ALTER STREAM changes the definition of an existing stream to associate or disassocite a wrapper. The ALTER STREAM ADD WRAPPER command is also used to specify which columns (if any) provide input values to wrappers
which require them in order to produce data.
Compatibility
SQL92
This command is specific to TelegraphCQ and may change in future
releases.