FirebirdSQL logo
  • Anglaiskeyboard_arrow_down
 SEQUENCE (GENERATOR)COLLATION 

Who Can Drop an Exception

The DROP EXCEPTION statement can be executed by:

  • Administrators

  • The owner of the exception

  • Users with the DROP ANY EXCEPTION privilege

DROP EXCEPTION Examples

Dropping exception E_LARGE_VALUE
DROP EXCEPTION E_LARGE_VALUE;
See also

[fblangref50-ddl-exception-create], [fblangref50-ddl-exception-recreate]

RECREATE EXCEPTION

Drops a custom exception if it exists, and creates a custom exception

Available in

DSQL

Syntax
RECREATE EXCEPTION exception_name '<message>'

!! See syntax of CREATE EXCEPTION for further rules !!

The statement RECREATE EXCEPTION creates a new exception for use in PSQL modules.If an exception with the same name exists already, the RECREATE EXCEPTION statement will try to drop it and create a new one.If there are any dependencies on the existing exception, the attempted deletion fails and RECREATE EXCEPTION is not executed.

RECREATE EXCEPTION Example

Recreating the E_LARGE_VALUE exception
RECREATE EXCEPTION E_LARGE_VALUE
  'The value exceeds its limit';
See also

[fblangref50-ddl-exception-create], [fblangref50-ddl-exception-drop], [fblangref50-ddl-exception-crtalter]