ALTER GENERIC OPTIONS Syntax

A set of comma separated name or name-value pairs with optional operation keywords, within an OPTIONS list.
alter-generic-options ::=
"{" OPTIONS ["("] alter-generic-option-list [")"] "}"
alter-generic-option-list ::=
alter-generic-option [ {"," alter-generic-option} ... ]
alter-generic-option ::=
[alter-operation ]option-name
[ {option-value |option-list } ]
alter-operation ::=
ADD | SET | XSET | DROP
The possible values for the alter-operation option are:
ADD Adds the option. Add is the default if an option is not specified.
SET Changes the option that already exists.
XSET Sets the option, if it has already been added. Or, adds the option if it does not already exist.
DROP Drops the option.
Note: If a value is omitted for alter-operation, the default operation is ADD.