YMatrix

Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

DROP RULE

Delete the rewrite rule.

Summary

DROP RULE [IF EXISTS] name ON table_name [CASCADE | RESTRICT]

describe

DROP RULE Rewrite rules in tables or views.

Parameters

IF EXISTS

  • If the rule does not exist, please do not report an error. In this case, a notification will be issued.

name

  • The name of the rule to be deleted.

table_name

  • The name of the table or view to which the rule applies (can be specified by the schema).

CASCADE

  • Automatically delete objects that depend on rules.

RESTRICT

  • If any object depends on the rule, the rule is denied. This is the default value.

Example

Delete the rewrite rules on the table sales_2006:

DROP RULE sales_2006 ON sales;

compatibility

DROP RULE is an extension of the YMatrix database language, and the same is true for the entire query rewrite system.

See also

ALTER RULE, CREATE RULE