|
|
|
Valid in: SQL, ESQL
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.)
|
|
|
The Drop Rule statement has the following format:
[EXEC SQL] DROP RULE [schema.]rulename;
|
|
|
In an embedded Drop Rule statement, a host language variable cannot be used to represent the rule name.
|
|
|
You must be the owner of a rule.
|
|
|
|
|
|
The following example drops the chk_name rule:
drop rule chk_name;