Drop Rules

To remove a rule from the database entirely, use the drop rule command.

Unbind the rule from all columns and user datatypes before you drop it. If you try to drop a rule that is still bound, SAP ASE displays an error message, and drop rule fails. However, you need not unbind and then drop a rule to bind a new one. Simply bind a new one in its place.

To remove phonerule after unbinding it:

drop rule phonerule 

The complete syntax for drop rule is:

drop rule [owner.]rule_name 
     [, [owner.]rule_name] ...

After you drop a rule, new data entered into the columns that previously were governed by it goes in without these constraints. Existing data is not affected in any way.

A rule can be dropped only by its owner.