ALTER RULE

Function

ALTER RULE modifies rule definitions.

Precautions

• Only the user who has applied a table or view of a specified rule can run the ALTER RULE command.
• Currently, only the rule name can be modified.

Syntax

AlterRule ::= ALTER RULE name ON table_name RENAME TO new_name;

Parameter Description

• name

  Specifies the name of the rule to be modified.

• table_name

  Specifies the name of the table for which the rule is to be created.

  Value range: an existing table name in the database.

• new_name

  Specifies the new name of the rule.

Example

ALTER RULE notify_all ON emp RENAME TO notify_me;