Was this helpful?
DROP RULE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
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 [IF EXISTS] [schema.]rulename;
IF EXISTS
Suppresses error reporting for the specified object if the object does not exist and the user matches the schema.
Embedded Usage
In an embedded DROP RULE statement, a host language variable cannot be used to represent the rule name.
Permissions
You must be the owner of a rule.
Related Statements
CREATE RULE
CREATE PROCEDURE
Last modified date: 08/29/2024