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

alter-operation

Indicates the required action for the specified options. If a value is omitted for alter-operation, the default operation is ADD. The possible values are:

ADD

Adds the specified option.

SET

Changes an option that already exists.

XSET

Sets the option if it has already been added. Otherwise, adds the option if it does not already exist.

DROP

Drops the specified option.