OR 12.0 | Drop Rule Statement

Language Reference Guide > Language Reference Guide > Statements > OpenROAD SQL Statements > Drop Rule Statement

Was this helpful?

Drop Rule Statement

The drop rule statement removes the specified rule from the database. (A rule is dropped automatically if the table on which the rule is defined is dropped.)

This statement has the following syntax:

drop rule [schema.]rulename;

Parameters--Drop Rule Statement

This statement has the following parameter:

rulename

Specifies the name of the rule to drop

Drop Rule Permissions

You must be the owner of a rule.

Examples--Drop Rule Statement

The following example drops the chk_name rule:

drop rule chk_name;

Last modified date: 06/25/2024