|
|
The DROP RULE statement deletes the specified rule.
ISQL or Application Programs
DROP RULE [Owner.]RuleName [FROM TABLE [Owner.]TableName]
- [Owner.]RuleName
identifies the rule to be dropped.
- [Owner.]TableName
identifies the table the rule is defined on.
If a TableName is specified, the rule must exist
on that table or an error will be returned.
If no TableName is specified, the rule is located
and dropped. Since rule names are unique per owner, not per table,
there is no ambiguity in references to
RuleName.
The DROP RULE statement invalidates stored sections that
have dependencies defined upon the table the rule is defined on. This
will permit the rule to be removed when the sections are
revalidated.
The procedure a rule invokes will not be affected by the removal
of that rule.
If no rule owner is specified and no table is specified, the
default owner is the current DBEUserID.
If no rule owner is specified and a table is specified, the
default rule owner is the table owner.
If a table is specified and no owner is specified for it, the
default table owner is the current DBEUserID.
The table and rule owners must be the same.
You can issue this statement if you have OWNER authority for
the rule or DBA authority.
DROP RULE PurchDB.InsertReport
DROP RULE PurchDB.DeleteReport
DROP RULE PurchDB.UpdateReport
|