ALTER RULE

Modify the definition of a rule.

Summary

ALTER RULE name ON table_name RENAME TO new_name

describe

ALTER RULE Changes the attribute of an existing rule and modifys the name of the rule when the operation is currently available.

To use ALTER RULE The user must be the table or view owner that the rule applies.

Parameters

name

  • The name of the existing rule to be changed.

table_name

  • The table or view name (optional qualified mode) to which the rule applies.

new_name

  • The new name of the rule.

compatibility

ALTER RULE is an extension of the YMatrix database language and is a complete query rewriting system.

See also

CREATE RULE, DROP RULE