Release History
Requirements

Introduction

Quick onboard

Deployment

Data Modeling

Connection

Write data

Migration

Query

Operations and Maintenance

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

ALTER RULE

Modify the definition of a rule.

Synopsis

ALTER RULE name ON table_name RENAME TO new_name

Description

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