Document

YMatrix

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