DROP EXCEPTION
From InterBase
Go Up to Statement and Function Reference (Language Reference Guide)
Deletes an exception from a database. Available in DSQL and isql.
DROP EXCEPTION name
| Argument | Description |
|---|---|
|
<name> |
Name of an existing exception message |
Description: DROP EXCEPTION removes an exception from a database.
Exceptions used in existing procedures and triggers cannot be dropped.
Tip:
In
In
isql, SHOW EXCEPTION displays a list of exceptions’ dependencies, the procedures and triggers that use the exceptions.An exception can be dropped by its creator, the SYSDBA user, and any user with operating system root privileges.
Example: This isql statement drops an exception:
DROP EXCEPTION UNKNOWN_EMP_ID;