HomeMogDBMogDB StackUqbar
v3.0

Documentation:v3.0

Supported Versions:

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;
Copyright © 2011-2024 www.enmotech.com All rights reserved.