HPlogo ALLBASE/SQL Reference Manual: HP 3000 MPE/iX Computer Systems > Chapter 10 SQL Statements

DROP RULE

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

The DROP RULE statement deletes the specified rule.

Scope

ISQL or Application Programs

SQL Syntax

DROP RULE [Owner.] RuleName [ FROM TABLE [Owner.]TableName]

Parameters

[Owner.]RuleName

identifies the rule to be dropped.

[Owner.]TableName

identifies the table the rule is defined on.

Description

  • 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.

Authorization

You can issue this statement if you have OWNER authority for the rule or if you have DBA authority.

Example

   DROP RULE PurchDB.InsertReport

   DROP RULE PurchDB.DeleteReport

   DROP RULE PurchDB.UpdateReport
Feedback to webmaster