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

DROP RULE

Delete the rewrite rule.

Synopsis

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

Description

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