English

DROP RULE

Delete the rewrite rule.

Synopsis

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

DROP RULE Rewrite rules in tables or views.

IF EXISTS

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

name

table_name

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

CASCADE

RESTRICT

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

Delete the rewrite rules on the table sales_2006:

DROP RULE sales_2006 ON sales;

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